In a separate post I am trying to export data from an Access query. The query has 4 linked tables. How do I import similar excel data into my Access ap when the tables that I am importing into contain linked fields.
How do I select the correct fields in the excel data for the correct tables. Will it automatically only import fields with matching names? or do the columns have to be specified?
Key fields are random number unique fields. Is it possible to specify numbers for these fields?