D
davant
I have a source excel file that contains data that needs t
append/update multiple tables. I am familiar with appends with
tables and I can perform updates; but how do i direct the query pu
records in the appropriate tables. My tables are participant, company
billingtransactions and conference. All the information for on
participant is in excel file. I have imported the excel data to a tabl
in access; that will be used as the source for updating and appending.
Can I do this in a single query?
thanks very much.
De
append/update multiple tables. I am familiar with appends with
tables and I can perform updates; but how do i direct the query pu
records in the appropriate tables. My tables are participant, company
billingtransactions and conference. All the information for on
participant is in excel file. I have imported the excel data to a tabl
in access; that will be used as the source for updating and appending.
Can I do this in a single query?
thanks very much.
De