Transferdatabase Table Export

[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.

 

[Roger Carlson]

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.