AutoCAD Map 3D General Discussion

Reply
Valued Contributor
chierchio
Posts: 85
Registered: ‎05-03-2009
Message 1 of 12 (758 Views)
Accepted Solution

Unable to conect to excel file using ODBC FDO provider

758 Views, 11 Replies
04-20-2012 12:14 PM

I have an excel spreadsheet of boreholes. The spreadsheet has the format of ID, X, Y, Z

 

I have tried using the 'Connect to Data' feature in Map 3D 2012 64 bit.

 

The ODBC connection is created and tests correctly. After connecting to the ODBC DSN and loggin in, I am able to see the fields identified in the excel file. There is also the Class available from the named range in the excel spreadsheet.

I select my Identity Property, X, Y, and Z - but that's as far as I can go. I have no opportunity to set the coordinate system and the 'connect' button does not activate.

 

Using Win 7 64 bit - and I have the 64 bit ODBC driver's installed.

 

Any ideas?

 

Thanks,

 

Chris

 

Distinguished Mentor
thepworth
Posts: 525
Registered: ‎03-02-2011
Message 2 of 12 (757 Views)

Re: Unable to conect to excel file using ODBC FDO provider

04-20-2012 12:52 PM in reply to: chierchio

first key is to work with a "Named Range" in your excel spreadsheet as the fdo source.....


C3D 2011
Intel Xeon E5630@2.53Ghz
NVIDA Quadro NVS420 Dual Monitor
12GB Ram / Win7 Professional 64bit SP1
Valued Contributor
chierchio
Posts: 85
Registered: ‎05-03-2009
Message 3 of 12 (755 Views)

Re: Unable to conect to excel file using ODBC FDO provider

04-20-2012 01:27 PM in reply to: thepworth

I have identified a named range in the spreadsheet. This shows up as a class item (which is unselectable).

Distinguished Mentor
thepworth
Posts: 525
Registered: ‎03-02-2011
Message 4 of 12 (752 Views)

Re: Unable to conect to excel file using ODBC FDO provider

04-20-2012 01:38 PM in reply to: chierchio

It's on my list to check out since I have some well data & corresponding spreadsheets.  I'll update when I've played with it.  The named range key came from one of my older postings and sending my files to AD for them to review since I was having a similar problem with FDO to ODBC with 64bit OS....


C3D 2011
Intel Xeon E5630@2.53Ghz
NVIDA Quadro NVS420 Dual Monitor
12GB Ram / Win7 Professional 64bit SP1
Distinguished Mentor
thepworth
Posts: 525
Registered: ‎03-02-2011
Message 5 of 12 (716 Views)

Re: Unable to conect to excel file using ODBC FDO provider

04-25-2012 08:19 AM in reply to: chierchio

O.K., I'm working with my data set again.  I've set up a "Named Range" in Excel and used the ODBC data source administrator with the 64-bit MS Access database engine installed.  I can FDO connect to the ODBC data source, when I connect to data, the named range shows up in the connection.  This is strictly a data table to color code various water contaminant MCL's for drinking water that I intend to join to my well points data set.  So, no coordinates within my Excel data.  When I connect to the data, I see the data column headers, but no data.  So, is this what's happening to you????  

 

I'm in need of more help on this myself - I can send it over to my colleague using E$RI, but I'd rather keep it in my own formats..... 


C3D 2011
Intel Xeon E5630@2.53Ghz
NVIDA Quadro NVS420 Dual Monitor
12GB Ram / Win7 Professional 64bit SP1
Valued Contributor
chierchio
Posts: 85
Registered: ‎05-03-2009
Message 6 of 12 (712 Views)

Re: Unable to conect to excel file using ODBC FDO provider

04-25-2012 08:37 AM in reply to: thepworth

I have an excel table with a named range and do not see anythng, nor am I able to check the class box. It is tricky to select the Identity property as well... it keeps wanting to go to <Click to select>. The excel table does have merged cells - though not in the named range. I have tried another excel table with just simple X,Y,Z and I am getting a result the same as you have described.. no data.

 

Seems like this is a bug with the OSGeo FDO Provider.

 

I can connect to the table using the Attach Data Source command in Map3D, but I cannot locate these as points in the drawing.

 

Looking forward to a resolution - good luck!

Chris

Distinguished Mentor
thepworth
Posts: 525
Registered: ‎03-02-2011
Message 7 of 12 (654 Views)

Re: Unable to conect to excel file using ODBC FDO provider

05-03-2012 09:45 AM in reply to: chierchio

Chris,

 

I'm still fighting with it here - per discussion with AD, I was told my problem is the lack of a unique key.  I've created a new column of ID's in my spreadsheet, but don't get the same connection window.  Specifically, I don't have an opportunity to select the identifier field.  What version are you using? 


C3D 2011
Intel Xeon E5630@2.53Ghz
NVIDA Quadro NVS420 Dual Monitor
12GB Ram / Win7 Professional 64bit SP1
Valued Contributor
chierchio
Posts: 85
Registered: ‎05-03-2009
Message 8 of 12 (651 Views)

Re: Unable to conect to excel file using ODBC FDO provider

05-03-2012 09:56 AM in reply to: chierchio

Using excel 2007 - C3D 2012 64 bit (The planning and analysis workspace)

 

Chris

Distinguished Mentor
thepworth
Posts: 525
Registered: ‎03-02-2011
Message 9 of 12 (644 Views)

Re: Unable to conect to excel file using ODBC FDO provider

05-03-2012 12:53 PM in reply to: chierchio

O.K. so I seem to be having success seeing the full table now - key was upgrading to 2012 & having a unique identifier column of data...


C3D 2011
Intel Xeon E5630@2.53Ghz
NVIDA Quadro NVS420 Dual Monitor
12GB Ram / Win7 Professional 64bit SP1
Valued Contributor
chierchio
Posts: 85
Registered: ‎05-03-2009
Message 10 of 12 (640 Views)

Re: Unable to conect to excel file using ODBC FDO provider

05-03-2012 01:00 PM in reply to: thepworth

and you can map the Points?

You are not logged in.

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

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

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

Ask the Community