I have a new database and need to populate a table from data in a spreadsheet. How does one go about doing that>
I assume your spreadsheet fits to the database. Then I mark a complete sheet an select copy from context-menu or with Ctrl+C. Now in the window of the database I select the destination-table and from its context menu select paste.
.
In the assistant wich comes up Ivusually select append data and to use the first row as column-namrs. The next screen helps to leave out columns.
.
Works usually without problems, but I never tried really big jobs. 4000 rows seem to pose no problem. I guess I never tried more than 10000 rows.
.
Expect problems, if your spreadsheet data does not fits to the definitions of the table.
I constructed the table to match the spreadsheet. I did limit the length of some of the fields. Perhaps I should go with the default field length until the data comes in.
I only have about 100 or so records, so that should be no problem.
I’ll give it a try–thanks.
I tried what was suggested: I opened the spreadsheet, selected the rows/columns and copied it to the clipboard. I then went to the database and clicked on the table I had constructed and selected “paste”. The menu that comes up is labeled "copy table’ and for some reason it did not pick up on the name and asked me for the name of the table. I wrote in the name and selected “append”.
It responds with "wrong data type and makes reference to Java script. Strange.
Aha! I tried it again without selecting a range of cells. I just selected the entire spreadsheet and it created a table with the data in it.
I will now try to append data to that.