unrecognized database format excel query

Other office/windows versions that it runs successfully on are His machine has been around the block a few times and probably had an earlier version of office either 2007 or 32-bit 2010 at some point.

In addition, I didn't have to install anything extra on his machine to run the program. My supervisor's machine (which will run it) is running the exact same versions of both office and windows. To the best of my knowledge, this is the only version of windows/office that has been installed on this machine. My machine (which won't run the program) is running Office 2010 64-bit and 64-bit Windows 7. This makes me think its a driver or office version issue. I'm not entirely convinced that the problem is the code itself because I'm able to successfully run the program on about half the computers in our office.

I've followed the advice of some other answers (specifically here) but am still receiving the error. Here is my connection method private static OleDbConnection GetConnection()ĬonnectionString = String.Format('Provider=.12.0 Data Source= Persist Security Info=False', accessFilename) The program throws the exception when I try to open the connection. The tables that are queried reside in a separate access file (Access2). The access queries are set up like so: The file I'm connecting to (let's call it Access1) has stored queries that I need to run. I'm having trouble establishing the initial connection to the access file. I'm writing a short utility program for a client that will run a series of queries on an access database and will save the resulting data tables to an excel file.

Unrecognized database format excel query