Table Export with TransferDatabase

[sunmorgus]

Hello, I have a really quick question...I tried using the TransferDatabase command to transfer some tables from my database to another (to create backups), but it only creates links in the backup database, rather than exporting them. here is the code I am using...

DoCmd.TransferDatabase acExport, "Microsoft Access", "m:\macsql\mdb\cs.mdb", acTable, "RMAs", "RMAs", False

I assumed since I was using acExport that all would work fine, but it only creates links. Can anyone help?

 

[denosaur]

You could create a Make-Table Query based on the table that you want to transfer to the backup database. In the Make Table dialog box, use the Table Name you want and point it to the backup database using the Another Database option.
Then you can use DoCmd.OpenQuery...

I hope that works for you.