Import Excel to related tables

[Nicole]

Hello:
I created an access database with several one-to-many
relationships. My question is now, how can I import data
so that I also get data entries in the related tables (if
there are any). All records I want to import are stored in
a huge Excel worksheet. So far I was only be able to
import in my main table.

Thanks in advance

Nicole

 

[Ronald W. Roberts]

Excel is not relational. You will have to import your excel table into
Access as 1 table.
Then using append queries, you can use some type of cirteria to select
and add the data to
each of your Access tables.

Ron