Inventor Engineer-to-Order

Inventor Engineer-to-Order

New Member
5 Posts
9 Kudos
Registered: ‎01-08-2013
Post 1 of 2

Error trying to connect to Excel as a data source

149 Views, 1 Replies
01-10-2013 08:18 AM

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

33 Posts
4 Kudos
Registered: ‎11-17-2011
Post 2 of 2

Re: Error trying to connect to Excel as a data source

01-15-2013 10:04 PM in reply to: keith.tyler

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.



Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.