Exporting and Importing Automated

[Guest]

I have setup a command button in an AccessXP database that exports data using
a query (query has 2 tables: a main table, and one related table) to an excel
spreadsheet with a specific name and location. I would like to import that
data into another AccessXP database. It must be automated as the both
databases will be .mde with no "File", "Get External Data" option.

It imports using a macro's "TransfereSpreadsheet" action, but problems
arise. Data imports into the main table, but not the related table.

Any suggestions welcome.

 

[Guest]

you will have to split your append query and append each
table seperately.
reason...you have to specify which table to append to.
if you are appending to 2 tables, you will need 2
statements stating which 2 tables.

 

[Guest]

Will there be a problem with the data linking correctly if I append
seperately? I didn't want to add ID numbers as this could potentially mess
things up.