Question Export the link table to another database (1 Viewer)

[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
<<<<<<<<<<<<<<<<<<<

 

[GohDiamond]

First, ask your question once in one area of the forum. Thanks.

1. Link your "Asset_Table" linked table directly to the other database and rename the link to whatever tablename you want.
   
2. If you want to save a snapshot of the linked table in your database, not recommended by the way, use a MAKE TABLE Query. You can put the MADE TABLE into the current database or into another database.

SQL: SELECT "Asset_Table.* INTO MyMakeTable IN 'd:\Database1.accdb'
FROM Asset_Table;​

Cheers!
Goh