Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / August 2004

Tip: Looking for answers? Try searching our database.

Importing Data into a table that have relationships

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Guy Verville - 26 Aug 2004 21:32 GMT
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 - 26 Aug 2004 23:57 GMT
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.
Signature

Joe Fallon
Access MVP

> Hi,
>
[quoted text clipped - 22 lines]
> Guy
> www.guyverville.com
Guy Verville - 27 Aug 2004 03:35 GMT
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
[quoted text clipped - 29 lines]
> > Guy
> > www.guyverville.com
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.