AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
Active Contributor
48 Posts
0 Kudos
Registered: ‎12-14-2009
Post 1 of 3

Join atributes from xls to table in shp

172 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*
1,793 Posts
194 Kudos
Registered: ‎06-03-2011
Post 2 of 3

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*
2,138 Posts
205 Kudos
Registered: ‎11-13-2006
Post 3 of 3

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