Transferdatabase Table Export

  • Thread starter Thread starter David
  • Start date Start date
D

David

When using the transferdatabase function within a macro,
how do you designate the table name within the database
you are exporting to?

I have a large database I am performing make-table
queries and exporting customer-specific data in tables
into their individual mdb files. Just having trouble
getting all the table names as I want them during this
data transfer.
 
You can't do it with a macro. Macro values are hard coded. That's one of
their drawbacks. However, if you convert the macro to a VB module, you can
programmatically substitute the table name.
 
Back
Top