P
pb100
Hi - I have a procedure to import data from Excel into Access. The data
needs to go into 3 related tables: Main, Details, Extra. Main has a primary
key ID that relates to the other 2 tables in a one to many relationship. I
am able to get the data into a temp table or three temp tables in Access
(tried both methods). Where I am stuck is in appending the data to the
tables and getting the ID of the record I imported to the Main table into the
data for the other 2 tables?? Basically, just like in using forms and
sub-forms to insert new data, how do I get the Main table ID value into the
data for the other 2 tables?
I have spent many hours trying to find a solution..:} Any help is greatly
appreciated!! I may just be missing something simple...
needs to go into 3 related tables: Main, Details, Extra. Main has a primary
key ID that relates to the other 2 tables in a one to many relationship. I
am able to get the data into a temp table or three temp tables in Access
(tried both methods). Where I am stuck is in appending the data to the
tables and getting the ID of the record I imported to the Main table into the
data for the other 2 tables?? Basically, just like in using forms and
sub-forms to insert new data, how do I get the Main table ID value into the
data for the other 2 tables?
I have spent many hours trying to find a solution..:} Any help is greatly
appreciated!! I may just be missing something simple...