Batch Export Multiple Tables

[Guest]

I want to export ten tables to another database. TransferDatabase seems to be
only able to export one table. Is there a way to export all ten tables at
once?

Thanks!

 

[Allen Browne]

Use TransferDatabase 10 times, or write a loop.

This link contains example code to create a database file, loop through all
the tables in the current database, skip system tables, temp tables, and
those marked not for backup, and export the rest into the new database,
logging any errors:
http://allenbrowne.com/unlinked/backup.txt

 

[Guest]

Thanks again, Allen!

Use TransferDatabase 10 times, or write a loop.

This link contains example code to create a database file, loop through all
the tables in the current database, skip system tables, temp tables, and
those marked not for backup, and export the rest into the new database,
logging any errors:
http://allenbrowne.com/unlinked/backup.txt

 

['69 Camaro]

Hello, Steve Santus.

Having another identity crisis? Perhaps you shouldn't repeat the same fake
names to post under. It makes it easier to find you when you're being
deceptive. You've already used Melissa Baker, Melissa Roberts, and Melissa
Smith:

http://groups.google.com/group/micr...8a5e5/40099e4f5bc60121?hl=en#40099e4f5bc60121

http://groups.google.com/group/micr...0eb73/0a9f4be6957cca7e?hl=en#0a9f4be6957cca7e

http://groups.google.com/groups?q=m...&scoring=d&hl=en&lr=lang_en&safe=off&num=100&

http://groups.google.com/groups?q=m...&scoring=d&hl=en&lr=lang_en&safe=off&num=100&

Perhaps you could try some new ones. Melissa Jones is too obvious. But who
would suspect it was really PC Datasheet if you used Grace?

HTH.
Gunny