Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.