If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hi, you can link external tables (via ODBC, ADO, etc.) in access via the "Link" command in the database view (my copy of Access is not in English, so I don't know the exact name of the command, so it could be named differently). With your external table linked you can perform append and update queries on it from your access tables. This however works only if the operations you need to perform on the records can be done with Access querying functions (Iif, etc.).

If your export requires some other operations that cannot be performed from within access, you can export the table to a CSV or similar file, perform the operations with an external tool, and reimport it back into access, where you can append it to the external linked table.