Export All Tables to Another Access Database

[Mike L]

I would like to write a procedure to export all tables from my current
Access database to another database. Can someone help? Thanks.

Mike

 

[Daniel Pineault]

You could use the built-in DoCmd.TransferDatabase; see

http://www.mrexcel.com/forum/showthread.php?t=294245

or you could write a custom function; see

http://www.databasedev.co.uk/import-data-with-vba.html
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Mike L]

Thanks, Daniel. What I really want to do is EXPORT to another database.
And I do not want to have to enumerate by name every table that is in the
source database. What I want is a vba procedure that will loop through all
the table names in my source database an export each to a specific, named
destination mdb database. Can you help me with this?

Mike

 

[Daniel Pineault]

You can adapt a function like the one found at

http://www.devhut.net/index.php?lang=en&id=0000000002#ListTbls

and combine it with the DoCmd.TransferDatabase to do exactly what you want.
Basically list each table and Transfer them one by one.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Mike L]

Many thanks, Daniel. That is exactly what I want.