AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
Active Contributor
ABielecki
Posts: 48
Registered: ‎12-14-2009
Message 1 of 3 (168 Views)

Join atributes from xls to table in shp

168 Views, 2 Replies
11-20-2013 07:00 AM

Sorry, if I repeat topic but I can't find any solution here.

Do you know how to join atributes from xls/xlsx to table in shp file?

I attache some sample files.

I have shp with 3 poligones. Each has two atributes in the table. I prepared some table in excel. Now I want to join this file to shp's table.

Do You have any Idea how to do this?

Should I connect this file though FDO? (ODBC)

 

GIS
*Expert Elite*
antoniovinci
Posts: 1,780
Registered: ‎06-03-2011
Message 2 of 3 (157 Views)

Re: Join atributes from xls to table in shp

11-20-2013 09:36 AM in reply to: ABielecki

Have the table and the shape a common ID..?

*Expert Elite*
Murph
Posts: 2,086
Registered: ‎11-13-2006
Message 3 of 3 (145 Views)

Re: Join atributes from xls to table in shp

11-20-2013 03:22 PM in reply to: ABielecki

First create a view in the Excell file.

Next use the Windows ODBC admin to create an odbc connection to that speadsheet/file

Then in Map3D use FDO to make a ODBC connection and select the odbc connection you created in the ODBC Admin.

Then you can create a join to the FDO connected shp file provided you have a command field in both.

Beware the version of Map3D, MS Office, and 63/32 bit os has a lot to it working.

 

Murph
Supportting the troops daily.
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.