Import Excel to related tables

  • Thread starter Thread starter Nicole
  • Start date Start date
N

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
 
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
 
Back
Top