B
bluegrassstateworker
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.
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.