Automating copying a table

[gransbpa]

Hi there,

I want to copy table from one database to another with lines of code. I used the TransferDatabase method as well as the CopyObject method, but both create a link to the original database table instead of an actual copy. This is not what I want, however: I want the actual table copied. Anyone know how to do this? Any help will be greatly appreciated.

 

[jinglin]

the following code will copy your table to another database, the path of your database location varies:

DoCmd.TransferDatabase acExport, "Microsoft Access", "c:/YourFolder/YourdatabaseName.mdb", acTable, "YourtableName", "YourtableName