Importing spreadsheet data to an existing database(Resolved)

Sugarplum · Last edited by Sugarplum on Mon Jul 27, 2009 6:52 am; edited 1 time in total

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

RPG · Posted: Mon Jul 27, 2009 5:20 am Post subject:

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

Sugarplum · Posted: Mon Jul 27, 2009 5:22 am Post subject:

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

RPG · Posted: Mon Jul 27, 2009 6:41 am Post subject:

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

Sugarplum · Posted: Mon Jul 27, 2009 6:51 am Post subject:

Woo hah!!

Thanks!!