Amalgamating similar tables

  • Thread starter Thread starter Bernie
  • Start date Start date
B

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
 
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.
 
Back
Top