Amalgamating similar tables

[Bernie]

Hi
I'm using Access 2000 and trying to create a table in a new database by
importing data from several Xcel spreadsheets, which are all in identical
layout.

I want to merge all the data from the Xcel spreadsheets into one table in
the Access database but am only able to import each spreadsheet into a
separate table.

The column headings in each of the spreadsheets are identical so I am
puzzled as to what stops me importing each spreadseet into the same table.

(the spreadsheets are an A-Z of contact information - there is just too much
to fit into one Xcel spreadsheet)

Right now I have twenty nine separate spreadsheets in a folder and also have
the same data in twenty nine separate tables in an Access database.

Can anybody suggest what I am doing wrong or help me find the easiest way to
merge all the tables into one big table.

Thanks

Bernie

 

[Douglas J. Steele]

Easiest approach is probably to link to each spreadsheet (as opposed to
importing them), and then run a series of Append queries to take the data
from each linked spreadsheet and save it in the table in your database.