Unlinking Tables

  • Thread starter Thread starter jroark
  • Start date Start date
J

jroark

I have a table that is linked from excel into access and it is giving me
grief. Is there a way to unlink the table? I'm using access 2000. Thanks!
 
Jeff Boyce said:
Open the Access database file. Use the database window, click on the Tables
tab.

Highlight the linked excel file in question and hit <Delete>. You'll be
prompted for whether you wish to delete the link.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
I think my question is similar: I'm using Access 2008 and used Excel to
import data, but I did it a weird way, and ended up with a linked table
instead of what I wanted. I don't need to keep the spreadsheet, and want to
continue to update the data in Access. What now?

I tried using a similar method to the above, but was told I couldn't delete
a database object while it was open.
 
Back
Top