Importing Data into a table that have relationships

[Guy Verville]

Hi,

I have a main table called "Choirs". It is linked with numerous ID to other
tables (MusicType (checked table), TypeVoices, Conditions, etc.).

In the other hand, my client gave me an Excel sheet containing 400 entries
that look somewhat like this:

Name Baroque Classical Popular.... Male Female
EvGanymède x x x x

In this example. EvGanymède sings Baroque, Classical and Popular, and is a
Male choir.
In other examples, a choir can be a Male/Female choir, a Children choir,
etc.

the Type of Music table contains the multiple choices and is linked with the
ID key to the Choir table.

So my question is: How do I import the Excel datasheet (400 entries) in
those tables? Is it possible to do it at once?

Guy
www.guyverville.com

 

[Joe Fallon]

You cannot do it during the import.
You have to import the data into a staging table and then write multiple
queries to update your real tables.
Once you have this built, you could accept future Excel files in the same
format and re-run your queries.
If it is just a one-time thing, then delete the staging table and quereis
when done.

 

[Guy Verville]

Thank you for this information.

Guy

You cannot do it during the import.
You have to import the data into a staging table and then write multiple
queries to update your real tables.
Once you have this built, you could accept future Excel files in the same
format and re-run your queries.
If it is just a one-time thing, then delete the staging table and quereis
when done.