When you use File/Get External Data:
Import makes a local table
Link makes a linked table
So, just use Get External Data and use the Import option.
If you delete your linked table first, it will import and create a local
table with its original name. If you do not delete your linked table first,
the table will have a number suffixed to the name (probably 1).
to "un-link" a table, just delete it from the database. when you link a
table into your database, you're not storing the actual table - just a
filepath to it; so deleting the link does not delete the table from the
other database where it actually "lives", it only deletes the link.
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.
