Single excel table to multiple access tables with relationships

[nshenry03]

I'm trying to import a single excel file into an access file with multiple tables that are linked together with relationships (1-many, 1-1, etc.). Any way to do this? When I go to import, I only have the option to import to one of these tables, and that is not what I want or need

 

[PHV]

One way is to import the excel table into a temporary access table and then use many append queries.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886