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