Inventor Engineer-to-Order

New Member
Posts: 5
Registered: ‎01-08-2013
Message 1 of 2 (127 Views)

Error trying to connect to Excel as a data source

127 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

Posts: 33
Registered: ‎11-17-2011
Message 2 of 2 (98 Views)

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.



You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

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

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community

Inventor Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for Autodesk Inventor helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Inventor