Error trying to connect to Excel as a data source

[keith.tyler]

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

[nagwani]

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