Problem with TransferDatabase export from back end

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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?
 
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.
 
Back
Top