Insert into multiiple tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have data I imported from Excel that I've put into one main table I called
"tblRawData". From here I performed some normilization and broke that table
down into 3 tables and created the relationships between each.

Because I may only get the data in an Excel Spreadsheet, is there a way to
either

1) Import into multiple tables and keep the relationships? or...
2) Import into my main table and create a query that inserts the data into
the three tables and keep the relationships. Can you create a query to insert
information into a query that saves the data?
 
Q1 sounds like a parent child relation. If the ParentID is in both the
Parent and child tables then it should be no problem to import the data to
the desired structure. You can turn off autonumbers(change to Number or
Long Integer) during the import process to ensure that new numbers are not
generated for the fields.

Q2 is possible with 3 append queries. Append queries save the data.


--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html
 
Back
Top