AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

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

Join atributes from xls to table in shp

156 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,700
Registered: ‎06-03-2011
Message 2 of 3 (145 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,012
Registered: ‎11-13-2006
Message 3 of 3 (133 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
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.