How get all values in comma delimited format when grouping (for use in ArcGIS)

[AJOSEPH]

Hello,

I have two tables Improvements and Properties that share a common PROP_ID The properties table has base information for each property and the Improvements file has a code describing individual buildings on each property (of which there are varying amounts) I want to group the improvements in one comma delimited field for each property ID

I need to know how to do the following (if this requires VBA please give me explicit directions as I tend to fail at using them):

PROP_ID IMPRV_CD


556433 33,56,65
554332 56,43,56,54
334564 76,23,43,98,87

OR

PROP_ID IMP1 IMP2 IMP3 IMP4 IMP5 ETC....
556433 33 56 65
554332 56 43 56 54
334564 76 23 43 98 87

[RuralGuy]

I'm pretty sure ArcGIS can read a dbf (dBase, FoxPro) file directly so why not just export your table to that format?

[AJOSEPH]

I know I can open it and that I could just use the spatial join option if i converted the shapefile that contains the properties info to xy data and then joined the coordinates to the improvements file, do add xy coordinates and then spatial join the xy coordinates of the buildings back to the properties shapefile specifying the join operate which would yield a csv list for each property polygon.

However, this would take alot of time in arcgis and require 4 unnecessary steps and as I do this task alot it would probably be faster if I just did it in access

[RuralGuy]

Maybe you will find this link helpful: http://allenbrowne.com/func-concat.html