Copy Linked Table to Local Table

[Brad Hall]

I would like to copy a table linked to another database and make a local
copy. In my tests, a local copy then local query is faster than a linked
query that uses most of the records. Any Help would be appreciated

 

[fredg]

I would like to copy a table linked to another database and make a local
copy. In my tests, a local copy then local query is faster than a linked
query that uses most of the records. Any Help would be appreciated

On your Main Database folder, delete the table. NOTE: You are NOT
really deleting the table, just the link to it.
Then click on File + Get External Data + Import.
Navigate to the other database, and select the table. Click on Options
and select Definition and Data.
Click OK.

 

[Brad Hall]

Sorry, I didn't make myself clear. I would like to do this programmatically.

 

[Brian]

1. Delete the link - something like this (or just leave it there and use a
different name in step #2 below):

Dim db As DAO.Database
Set db = CurrentDb
db.TableDefs.Delete "MyLinkedTable"

2. Import the table - something like this:

DoCmd.TransferDatabase acImport, "Microsoft Access", _
"C:\MyOtherDB.mdb", acTable, "MyTableThere", _
"MyTableHere"