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 ...
Depending on the sheet version you sometimes have to specify the username/password so i just always include them as an example. Glad you got it working anyhow.