Inventor Engineer-to-Order

Inventor Engineer-to-Order

Reply
New Member
keith.tyler
Posts: 5
Registered: ‎01-08-2013
Message 1 of 2 (142 Views)

Error trying to connect to Excel as a data source

142 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:

ETO-ExcelError.jpg 

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

Employee
nagwani
Posts: 33
Registered: ‎11-17-2011
Message 2 of 2 (113 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.

 

http://www.microsoft.com/en-us/download/details.aspx?id=13255

 

-Ishwar

Post to the Community

Have questions about Autodesk products? Ask the community.

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