Transferdatabase Table Export

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Creating a Chart on form from selected data in query. 0
VBA - exporting serial letters to single documents 0
How can I TransferDatabase a backend table from the frontend? 2
Consolidation Table from Different Excel Tabs with Different Format 1
Migrating from 2010 to 2013 - having issues: Exporting to xml 0
List all tables, including document structure 0
Access TransferDatabase Does Not Import 2

Top