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?
"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?