AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

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

Join atributes from xls to table in shp

161 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)


*Expert Elite*
Posts: 1,740
Registered: ‎06-03-2011
Message 2 of 3 (150 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*
Posts: 2,053
Registered: ‎11-13-2006
Message 3 of 3 (138 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.


Supportting the troops daily.
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!