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!

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Melissa" <(E-Mail Removed)> wrote in message
news:44FFCBD5-1550-4FE9-8FEE-(E-Mail Removed)...
>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!

Thanks again, Allen!

"Allen Browne" wrote:

> 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
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Melissa" <(E-Mail Removed)> wrote in message
> news:44FFCBD5-1550-4FE9-8FEE-(E-Mail Removed)...
> >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!
>
>
>

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/micro...099e4f5bc60121

http://groups.google.com/group/micro...9f4be6957cca7e

http://groups.google.com/groups?q=mr...e=off&num=100&

http://groups.google.com/groups?q=ms...e=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


"Melissa" <(E-Mail Removed)> wrote in message
news:44FFCBD5-1550-4FE9-8FEE-(E-Mail Removed)...
>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!