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!
Thanks!
use the copyobject command
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
Ab-so-lu-te-ley brilliant. Thanks!!
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)