Link to home
Create AccountLog in
Avatar of Stephen Roesner
Stephen RoesnerFlag for United States of America

asked on

Export access table From one access database to another access database

I was wondering if there is vba code that will allow me to export one access table from one access database to another access database
Avatar of Corey Habbas
Corey Habbas
Flag of United States of America image

Yes, definately!  This article explains how to do that very nicely..
http://www.databasedev.co.uk/exporting-data-with-vba.html

The author of the above article has a full tutorial and code as well.  I hope this helps...
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
If you have current.mdb opened and you want to transfer tblA in path1\db1.mdb to tblB in path2\db2.mdb it is a bit more complicated than either solution above.  However. Christmas is just round the corner and I must shut this thing down for more important events.  I'll check back in on Boxing Day if the question is still open.
no vba code
Thanks