How do I unLINK a table in Access?

  • Thread starter Thread starter mwh2385
  • Start date Start date
M

mwh2385

I imported a spreadsheet, in .csv, from Excel to MS Access, but the table
finshed up LINKed. Did I forget a step or did I do something wrong? How do I
unLINK a table. I don't want to delete the table. Please help.
 
Delete the linked table (which is actually just a reference to the
spreadsheet) in your Access database, then repeat the import, but this time
do NOT choose the "Link" option.

Rob
 
mwh2385 said:
I imported a spreadsheet, in .csv, from Excel to MS Access, but the table
finshed up LINKed. Did I forget a step or did I do something wrong? How do
I
unLINK a table. I don't want to delete the table. Please help.
Click to expand...

Rob is correct, but let me add something.

Linked tables always have a small black arrow pointing toward the icon. ODBC
connected tables use a small globe icon without the arrow. If you imported
the table, you can delete it, losing only the copy you've imported. Deleting
a link drops the link, but does nothing to the original data.
 
Back
Top