Link to home
Start Free TrialLog in
Avatar of keimpe
keimpe

asked on

How to export a table from one external Access db to another external Access db?

Using VBA in Access database A is it possible to copy/export/transfer a table from Access database B to Access database C?

Thanks!
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

use the copyobject command
Avatar of keimpe
keimpe

ASKER

That will copy a table from A to C, but I want to use code in database A to copy a table from external(source) database B to external (target) database C
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Sorry , misread the Q.
That's a bit trickier- need a few moments to consider..probably use opencurrentdatabase but need to check.

I assume you want to copy the full table definition, not just the data, otherwise you could use a make table query based on a linked table.
Avatar of keimpe

ASKER

Ab-so-lu-te-ley brilliant. Thanks!!
Avatar of keimpe

ASKER

Thanks for your feedback peter! Fortunately I already got a working solution (eventhough it doesn't copy the exact table definition, but this is a very efficient solution for my current needs)