I'm using TC10 on windows 7 with Office 2010 and I'm trying to connect to Excel and select the data with an SQL statement. When my Excel file was still .xls and I used the Jet4 connection string, it worked fine. So I saved my file as Excel 2010 (.xlsx) and updated the connection string to what's shown below and it started to fail. We are running the 32bit office so I installed the 32bit access piece from Microsoft but I still get the error. The error comes on the connection.open line.