Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am able to successfully import an Access .accdb table into my Excel 2010 worksheet. However, it still seems to maintain a connection to the data. This is an inconvenience for me because I have to manually disconnect it in the event that I need to use a third party program to export data into the Access database again. Otherwise, it throws an exception saying that the Access database is in use by another application.

Is there a way to just to a one-time dump into the worksheet where no connections are maintained at all so my workflow is as smooth as it can be?

share|improve this question
these instructions are for 2007, but can't you just copy/paste? You could also just open the db with excel and save-as xls to have a copy – Raystafarian Feb 23 '12 at 14:49
I don't have Access on my work PC, so I have to import the table through Excel. That link you showed seems to require Access except for the import through Excel which I've already been doing. I am guessing the only way to do what I want is how I've already been doing it, which is to connect to Access then remove the connection manually. – oscilatingcretin Feb 23 '12 at 15:07
Just open the DB with excel and use save as to save a copy with no links. Go to data - connections - remove to remove the connection – Raystafarian Feb 23 '12 at 15:10
up vote 1 down vote accepted

You can import the data the usual way, but break the connection at data - connections select the connection and hit remove

share|improve this answer
Yep, this is pretty much the only option I came across. Not a big deal, but I was hoping for one less step in the process of automating this manual task. Thank. – oscilatingcretin Mar 26 '12 at 13:24

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .