Moving Data from Excel to Access

[Homegrownandy]

The data I have in excel is basically everything about the "site". In access this cant be stored in one table.



What's the best way to move data from excel into access across multiple tables? I was hoping I could create a query and assign the columns from excel to the columns in the query. but I cant see an option for this.

Any tips appreciated.

Andy,

[CJ_London]

you need multiple queries - one for each table

Easiest way is to create a linked table to excel, then create append queries for each table

[Homegrownandy]

Okay ill look into it, Thanks.