Programatically copying a table between two databases 2

VBAguy22 · Mar 31, 2004

Hello,
How do I copy myTable from C:\myDB1.mdb to C:\myDB2.mdb programatically using VB?

p27br · Mar 31, 2004

have a look at Docmd.transferdatabase

VBAguy22 · Mar 31, 2004

Do you have a code example?
It's not working for me

I put down

DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\myDB1.mdb", acTable, "myTable", "C:\myDB2.mdb

chris153 · Mar 31, 2004

Hi,

Try this code in MyDB1:

DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\MyDB2.mdb", acTable, "MyTable", "MyTable"

p27br · Mar 31, 2004

thanks for the star !
happy it helped

paul