Export tables from another database

  • Thread starter Thread starter xanders
  • Start date Start date
X

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!
 
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
 
Back
Top