Exporting a linked table

[Guest]

Hello,

In a split database set-up, is it possible to export a linked table, using
the TransferDatabase Method, to a third database while ensuring that the
actual table has been transferred and not the link.

DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\Archive.mdb",
acTable, "tbl_test", "tbl_test"

Thank you

 

[Tim Ferguson]

In a split database set-up, is it possible to export a linked table,
using the TransferDatabase Method, to a third database while ensuring
that the actual table has been transferred and not the link.

DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\Archive.mdb",
acTable, "tbl_test", "tbl_test"

Dunno about using TransferDatabase, but the normal SQL maketable command
will definitely work:

strSQL = "SELECT * " & _
"INTO Test IN c:\archive.mdb " & _
"FROM Test"
db.Execute strSQL, dbFailOnError

HTH


Tim F

 

[Guest]

Thank you Tim. That solution will work for me.

Dunno about using TransferDatabase, but the normal SQL maketable command
will definitely work:

strSQL = "SELECT * " & _
"INTO Test IN c:\archive.mdb " & _
"FROM Test"
db.Execute strSQL, dbFailOnError

HTH


Tim F