Problem with TransferDatabase export from back end

[Guest]

I'm trying to export tables from my database. Before i split it it worked
fine, using standard TransferDatabase syntax

DoCmd.TransferDatabase transfertype:=acExport, _
databasetype:="Microsoft Access", _
databasename:="destination database with path", _
ObjectType:=acTable, Source:="SourceTableName", _
Destination:="DestinationTableName"

After splitting the databse, it's exporting links, not the actual data. I've
tried, but can't seem to properly reference the back end database table tthat
actually has the data in it. I'd appreciate any suggestions.

 

[Allen Browne]

What happens if you create a query into SourceTableName, and export that?

 

[Guest]

It seems to work just fine, and solves my problem. Thanks very much for the
help. Is that the standard way to export data/tables from a back end?

 

[Allen Browne]

I almost always export a query because it's so much more flexible that the
table: multiple tables, calculated fields, formating fields (currency,
dates, case), selective fields, sorting, criteria, grouping, ...

You can OpenDatabase() if you really need to operate on the other database
directly.