Hi - I have a procedure to im****t 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 relation****p.
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 im****ted 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...
--
-pb100
