Hi Andy,
I'm new to excel programming.
I got similar task to do but don't know from where to start.
It would be great if you help me out by sending the sample code which
you used.
Thanks in advance.

Regards,
Abhilash

On Feb 9, 12:12*am, bluegrassstateworker
wrote:
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.