Hi


I have a 2 tables: One that is empty (access table called Barriers) and one excel table that has records (also called barriers). They have similar fields.

Basically, i want the records from the excel table to be in the access table. I am in the process of populating an empty database from various data sources.

How can i most easily do this? Do the tables need to have matching fields?

Thanks for your help

Sue

If they have matching fields, you can use the TransferSpreadsheet Method/Action to do the append. If not, you can link to the Excel spreadsheet and then create an append query that selects columns from the linked Excel spreadsheet and appends them to the columns you select in the Access table.