My problem is now FIXED!
For some reason, neither my Windows7, not my Excel installations included the latest Access Database Engine 2010. I downloaded the latest drivers, installed them. Made a User and System DNS ODBC definition for 2003-2010, in addition to the 97-2000 definitions already there.
I modifed my script to the following:
Code: Select all
Let>XLINPUT=C:\Data\Temp\MyInfo.xlsx
Let>connSTR=Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%XLINPUT%;Extended Properties= "Excel 12.0 Xml;HDR=NO";
DBConnect>%connStr%,dbH
The site where I got the info about the drivers is here:
http://www.microsoft.com/en-us/download ... x?id=13255
I was able to download drivers from that site.
And here is a summary of some of the connection info they provided to use with the Access Database Endine 2010 drivers:
==============================
If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to "Microsoft.ACE.OLEDB.12.0"
If you are connecting to Microsoft Office Excel data, add the appropriate Extended Properties of the OLEDB connection string based on the Excel file type:
File Type (extension) Extended Properties
---------------------------------------------------------------------
Excel 97-2003 Workbook (.xls) "Excel 8.0"
Excel 2007-2010 Workbook (.xlsx) "Excel 12.0 Xml"
Excel 2007-2010 Macro-enabled workbook (.xlsm) "Excel 12.0 Macro"
Excel 2007-2010 Non-XML binary workbook (.xlsb) "Excel 12.0"
If you are an application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to "Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file"
If you are an application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file"
And thanks to Me_again for offering to backup my search for ODBC info with Windows7. Hope this reply is in time to save you that work.
