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 spreadsheet data to an existing database(Resolved)

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


Joined: 02 Jun 2009
Posts: 13
Location: Kent. England

PostPosted: Mon Jul 27, 2009 4:57 am    Post subject: Importing spreadsheet data to an existing database(Resolved) Reply with quote

How can i import say 147 records that i have in a spreadsheet, to an already existing database with some records? I cant find a way and i dont feel like copy pasting every piece of data manually. It might take a while!

Cheers

Sarah


Last edited by Sugarplum on Mon Jul 27, 2009 6:52 am; edited 1 time in total
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Mon Jul 27, 2009 5:20 am    Post subject: Reply with quote

Hello

Copy the spreadsheet
and past it in the database.
Choose carefull those thing you need.
You must not see the table in grid mode but see all the table names

Romke
Back to top
View user's profile Send private message
Sugarplum
General User
General User


Joined: 02 Jun 2009
Posts: 13
Location: Kent. England

PostPosted: Mon Jul 27, 2009 5:22 am    Post subject: Reply with quote

Im not sure what you mean? As far a copy paste goes it seems to try and insert the whole spreadsheet into one cell in base
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Mon Jul 27, 2009 6:41 am    Post subject: Reply with quote

Hello
Copy spreadsheet table
Goto the database not in the databrowser , but where you can see the names of the forms and tables.
select now first the table view: You see all the table names
select now the table in which you want add the data
right the mouse select paste
look now if the table is the good name and select the other thing who are important for you.
click ok next

I hope this is more clear.
Romke
Back to top
View user's profile Send private message
Sugarplum
General User
General User


Joined: 02 Jun 2009
Posts: 13
Location: Kent. England

PostPosted: Mon Jul 27, 2009 6:51 am    Post subject: Reply with quote

Woo hah!!

Thanks!!
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