Export the link table to another database

[wschian]

Hi ! I want to export my data in "Asset_Table" link table to another file store in "d:\Database1.accdb" with table name "AssetList". The Code i used as below. But when i opening the "Database1" file, the Table "Assetlist" is a LINK table type (I want Local Table). Anyone got ideal how to export the Link table data to Local Table data on another Database file.
:banghead::banghead:

<<<<<<<<<<<<<<<<<<<<<<
Private Sub Copy_Click()
DoCmd.TransferDatabase transfertype:=acExport, _
databasetype:="Microsoft Access", _
databasename:="d:\Database1.accdb", _
ObjectType:=ACTable, Source:="Asset_Table", _
Destination:="AssetList", structureonly:=False
End Sub
<<<<<<<<<<<<<<<<<<<

 

[Cronk]

I can think of 3 ways.

The sledge hammer approach would be to import the table into your front end, export it, and then delete it.

Another would be to write a make table query on the linked table to create a table in the destination db.

A third would be to set a database reference to the other db's and reference the TableDef for the particular table