AutoCAD Map 3D General Discussion

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

Join atributes from xls to table in shp

145 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,603
Registered: ‎06-03-2011
Message 2 of 3 (134 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: 1,935
Registered: ‎11-13-2006
Message 3 of 3 (122 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.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community