topic Re: Add a single column from excel table to an existing attribute table in Data Management Questions

Add a single column from excel table to an existing attribute table

AndreasGriessbach — Wed, 15 Feb 2017 09:54:44 GMT

Hallo to everyone.

I have read that changes directly in the *.dbf of the shapefiles could damage the shapefile and in deed I tried it (with libre office) and I get some problems. Anyway, my goal is to change whole columns of the attributable by replacing contents which already exist in a excel file (with the same number of rows and the same order of course), e.q. by a method like copy and paste.

Unfortunately I didn’t find any advice how to realize it without open the *.dbf directly.

Thanks so much for any support.

Andreas

Re: Add a single column from excel table to an existing attribute table

JayantaPoddar — Wed, 15 Feb 2017 10:14:01 GMT

Check Join Field. In case it doesn't accept the Excel sheet for Join Table, you might want to use it as a CSV or convert it to a table Excel to Table.

Re: Add a single column from excel table to an existing attribute table

AndreasGriessbach — Wed, 15 Feb 2017 11:38:14 GMT

Dear Jayanta,

thanks a lot. It works fine! With your help I find an additional Video tutorial:

https://www.youtube.com/watch?v=vedylf2pMjQ

have a nice day! Andreas