Convert Linked Table to Local Table in Access 97
I have tried;
So how do we convert linked tables to local tables in a different database not necessarily the original linked database.
I have tried;
- Copy and paste method but it seems i have to append to an existing table with the exact same fields.
- Using VBA in 97 doesn't allow to make a local copy
- All other user interfaces have been explored.
So how do we convert linked tables to local tables in a different database not necessarily the original linked database.