AutoCAD Map 3D Forum
Welcome to Autodesk’s AutoCAD Map 3D Forums. Share your knowledge, ask questions, and explore popular AutoCAD Map 3D topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Unable to conect to excel file using ODBC FDO provider

11 REPLIES 11
SOLVED
Reply
Message 1 of 12
chierchio
1518 Views, 11 Replies

Unable to conect to excel file using ODBC FDO provider

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

 

11 REPLIES 11
Message 2 of 12
thepworth
in reply to: chierchio

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

Message 3 of 12
chierchio
in reply to: thepworth

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

Message 4 of 12
thepworth
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....

Message 5 of 12
thepworth
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..... 

Message 6 of 12
chierchio
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

Message 7 of 12
thepworth
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? 

Message 8 of 12
chierchio
in reply to: chierchio

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

 

Chris

Message 9 of 12
thepworth
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...

Message 10 of 12
chierchio
in reply to: thepworth

and you can map the Points?

Message 11 of 12
thepworth
in reply to: chierchio

in this case, the data is extended attributes (water quality sampling for MCL's) against existing wells.  Since the I'm attaching to a .SHP from the state well data set, I'm intending to perform a join to stylize points based on the sampling results.  so, I haven't tried to add points by their coordinates.  When I have some time, I'lll try & let you know what happens.

 

TdH

Message 12 of 12
chierchio
in reply to: thepworth

I was finally able to connect to the excel file and map the points.

There was a duplicate point in the spreadsheet that I missed. Created another column with IDX(index) and everything works now.

 

Thanks for your input.

 

C

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost