OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Importing records from .xls to an exisiting database table

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
jlb123
Newbie
Newbie


Joined: 23 Feb 2007
Posts: 2

PostPosted: Fri Feb 23, 2007 11:18 am    Post subject: Importing records from .xls to an exisiting database table Reply with quote

I have records that need to be imported into an existing database table - There are over 400 entries, I cannot just re-enter the information, and I already have a database to use so I don't want to create a new "database" just because I need to import records.

Can anyone point me in the right "importing" direction Very Happy
Back to top
View user's profile Send private message
alan4171
General User
General User


Joined: 19 Feb 2007
Posts: 9
Location: Sydney, Australia

PostPosted: Fri Feb 23, 2007 2:35 pm    Post subject: Reply with quote

Open your database
Select the Table tab
Open new Calc sheet
Load the .xls into Calc
Delete any column headings
Select all
Drag to Base
New Tbale Wizard starts
Give it the name of the Table you want to add records to
Select Append check box.
Click Next and follow the Wizard.
Back to top
View user's profile Send private message
PromptJock
Super User
Super User


Joined: 26 Jul 2006
Posts: 741

PostPosted: Fri Feb 23, 2007 2:43 pm    Post subject: Reply with quote

Assuming your "database" is a simple Excel spreadsheet, just open the .xls with Calc. The spreadsheet should open just as it did with Excel. If necessary, verify the column headings are what you want them to be and ensure all yoru "data" is otherwise intact (formatting, column widths, etc.).

Next, resave the sheet in Calc (.ods) format ("File, Save As..." from the Menu Bar, then select "OpenOffice.org Spreadsheet (.ods)" as the format, then click the "OK" button). You can use the same "base" name as your Excel spreadsheet.

Now, register the newly-created .ods as a database Source from whatever OOo application (Writer, Base) you wnat to use it with. Voila! your data SHOULD be there, ready and waiting for you to use. Smile

If this doesn't work, then use alan4171's method. Smile

Good luck and always be in awe of your OOo....
_________________
I'm making perfect sense - you're just not keeping up!
Back to top
View user's profile Send private message
jlb123
Newbie
Newbie


Joined: 23 Feb 2007
Posts: 2

PostPosted: Fri Feb 23, 2007 3:32 pm    Post subject: Thank you sooo much Reply with quote

I have been trying to import that data forever - OH MY god - It's there......I can finally finish my project

As simple as a drag and drop.......... can't tell you how much time that saved me.

Thanks very much Laughing Laughing Laughing Laughing Laughing Laughing
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group