Export tables from another database

[xanders]

Do somebody have some code (syntaxis) to copy (export)
tables from database A to database B.
At the moment I control it manualy.
I do not mean to link the table!

 

[Laurie Eaton]

Hi Xanders

Have a look at MSAccess help which reads -

"TransferDatabase Action
You can use the TransferDatabase action to import or export data between the current Microsoft Access database (.mdb) or Microsoft Access project (.adp) and another database."

I have used it to automate export to DBase - tricky to get going but otherwise worked fine.

regards Laurie Eaton