how to unlink tables

B

Bob Levin

Hi : Linking tables is easy. How does one un-link tables? It must be just
as easy but I can't seem to find that option. Thanks much.
 
S

SteveM

You want to make a linked table a local table?

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).

Steve
 
T

tina

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.

hth
 
Top