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 CSV files

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


Joined: 14 Mar 2010
Posts: 3

PostPosted: Sun Mar 14, 2010 12:28 pm    Post subject: Importing CSV files Reply with quote

I've been trying to figure out exactly how to import a .CSV file I have into Base and can't quite seem to get there. I've created a new Database, and want the info from the CSV file to be a table in my Database, but when I just "open" the CSV file from within Base it just opens as a spreadsheet and I can't figure out how to create a table using that data.

Any help would be much appreciated here!
Back to top
View user's profile Send private message
dacm
Super User
Super User


Joined: 07 Jan 2010
Posts: 769

PostPosted: Sun Mar 14, 2010 1:03 pm    Post subject: Reply with quote

If it's a flat-file database csv with a column-name row...Then as I recall you simply Open the csv in Calc, drag-select cells in Calc (or select the last lower-right cell and then shift-select A1) and drag & drop onto the Tables icon in Base, and follow the popup Wizard.
Back to top
View user's profile Send private message
Decepticon
Newbie
Newbie


Joined: 14 Mar 2010
Posts: 3

PostPosted: Sun Mar 14, 2010 1:08 pm    Post subject: Reply with quote

That worked! Thanks a lot, dacm. Appreciate the help.
Back to top
View user's profile Send private message
rafe678
Newbie
Newbie


Joined: 14 Oct 2010
Posts: 3

PostPosted: Mon Oct 25, 2010 12:56 am    Post subject: Reply with quote

That worked fine. Thanks for your help.
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