How do I unLINK a table in Access?

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

Rob Parker

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
 
A

Arvin Meyer [MVP]

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.
 

Ask a Question

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.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Export BPMN Visio Chart to Excel 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Help creating a search form in Access XP 0
Dealing with a Pivot Table (when I don't want to) 0
How do i delete an old Outlook account from ex employers? 1
Create a chart from a table in word thats dynamic 0
HELP, PLEASE! Unlink a table 15

Top