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

691
2
Jump to solution
02-15-2017 01:54 AM
Highlighted
New Contributor III

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

Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
Honored Contributor

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.

View solution in original post

2 Replies
Highlighted
Honored Contributor

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.

View solution in original post

Highlighted
New Contributor III

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