In these kinds of situations, you will often times need to look at
transactions. For addtional information on this, you can go into Access's
help file and look up the "About batch transactions", and go from there.
You can also setup links within the front end portion of an Access database
(provided you have and you should split the database into 2 parts, back end
and front end), so as you can stay within Access to use the batch
transaction tools. This will help keep your data validated should something
happen in between the start of transfer time and end of transfer time, so as
you don't have orphaned data or some other issue of data missing.

Sincerely,

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000

"bluegrassstateworker" wrote in message
...
Hello all:
I successfully use ADO to upload form data from an Excel spreadsheet
to an Access db but would now like to take it to a new level: Instead
of opening just one single table, I would like to add information to
other tables. For example, part of the spreadsheet would upload to an
ORDER_HEADER Table and another part of the same spreadsheet would
upload order details to the ORDER_DETAIL Table. These two tables are
related of course. My thought is: establish the value of the primary
key in the first part of the upload then use that value obtained to
open another table and upload with that primary key value.
I think the concept is valid but the details are elusive. Havent
seen any postings covering relational input. Any info on this subject
appreciated.