Dear Kwozy:
You can create a linked table that is actually what is in a spreadsheet:
1. select the database window, and tables
2. right click on a blank area within the window
3. choose Link Tables
4. at the bottom of the new window, there is Files of Type. Choose
Microsoft Excel from the list.
5. navigate to the folder and choose the spreadsheet.
6. You can choose named ranges, or worksheets. Choose the desired one.
You must do them one at a time. Each will become one table in your
database.
7. click Next and tell it whether the first row is column headings (I hope
it is! Your columns in the table will then be named accordingly.)
8. click Next and give the name for this as a table.
I did this as a created this instruction list, and it works for me.
Now, you can instead create an empty table and import. For one-time or
occasional use, just copy and paste works well. Otherwise, create the
linked table and use a query to copy the data. An append is preferred.
This means you must create the destination table ahead of time (you can do
this once and copy it when a new one is needed if the columns don't change).
However, that gives you complete control over everything. A make-table may
work as well, but you lose some control.
Tom Ellison
