Importing Excel datasheets into multiple tables

[FishMT]

I am a new user to access and have a problem for which I cannot seem to find an answer. I am having difficulty importing one excel datasheet into multiple tables in access. I can get most of the data into the db but it does not seem to be related. I have been experimenting with append queries by bring the data from the entire excel sheet into a temporary table that contains all of the field names of the tables to which I would like to append the data. The problem comes when I try to append the data into the multiple tables. How does one make sure that referential integrity is maintained when the data is seperated from the temporary table into the multiple tables?

Thanks for any help

[ajetrumpet]

you can't possibly create new RIs mechanisms or relationships from newly created tables without utilizing vb code. Automation within this aspect can only be done via that method. Otherwise, you'll have to click on the relationship mgr after they're all in there and do it yourself.

[FishMT]

I thought that this might be the case as I could not find an easier answer.
Thanks!

[thhui]

Try to append data from the temporary table to what should be the most correct structured-tables whose design is normalized with linked relationship one by one.

They would be all-right after the above operations.