Problem with TransferDatabase export from back end

R

RWilly

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.
 
R

RWilly

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?
 
A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top