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?