Community
I am trying to connect to an Excel spreadsheet as a data source and receive an error. Here is the code:
Design ODBC_Example : DefaultRoot IvAssemblyDocument Rule MyDataProvider As Name = :ODBC Rule MyConnectionString As String = "Driver = {Microsoft Excel Driver (*.xls)}; DriverId = 790; Dbq = c:\DatabaseExport.xls; DefaultDir = C:\;" Rule MyTableNames As List = MyDbConnection.getTableNames( ) Child MyDbConnection As :dbConnection dataProvider = MyDataProvider ConnectionString = MyConnectionString End Child End Design
Here is the error I receive when evaluating the MyTableNames rule:
Here are the specifics regarding the hardware and software configuration of the machine:
MS Windows 7 Enterprise SP1 - 64bit
Autodesk Inventor Professional 2013 - 64 bit
Autodesk Inventor Engineer-to-Order Series 2013 R1 - 64 bit
MS Excel 2010 - 32 bit
Hi Keith,
You cannot use 32 Bit OLEDB drivers on 64 bit Windows and 32 Bit Excel. You have to install 64 bit office 2010 and download the 64 bit OLEDB driver from following URL.
http://www.microsoft.com/en-us/download/details.aspx?id=13255
-Ishwar