Copy and Paste Fields from Different Standalone Tables (ArcGIS Pro)

[JasonBritton1]

I feel like this is going to be a "oh yeah, that was obvious" moment when I get answers, but I'm at a bit of a loss. I've got an excel table with a list of about 2500 road names that I want to paste into the Address Data Management Solution's Master Road Name Table. When I do a copy/paste it only pastes about 10 records and it tries to fit them in one field.

I've tried to add the excel table to the map and do a join, but that doesn't seem to work. I've tried to calculate the field, but I can't select another table for my input info. Any ideas will be much appreciated.

[JasonBritton1]

Workaround seems to be append. Has to be a better way though. 

[AdrianWelsh]

Jason,

If you're copying records (rows) from a table that has the same attributes (fields/columns) as your feature layer that you're copying into, it seems that Append is a good tool to use for this. What problems have you found with append?

Maybe Copy Rows could be an option too (depending on what you're doing)?

https://pro.arcgis.com/en/pro-app/2.8/tool-reference/data-management/copy-rows.htm

Or maybe even copy features?

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/copy-features.htm

(perhaps just plain copy and paste: https://pro.arcgis.com/en/pro-app/latest/help/editing/copy-and-paste-using-the-clipboard.htm)

[JasonBritton1]

You can’t use copy features because there are no features in standalone tables. I’m copying, columns not rows. Append is a good workaround if you use the field map, but it’s still a little clunky. 

[AdrianWelsh]

Oh ok, I thought you mentioned copying records/rows.

The way I do it is first select the layer in the table of contents. Click on the Data tab at the top, then the Fields button. This opens up your fields (columns). 

From here you can select as many fields as you need to and Copy them to the clipboard. Then you can paste those same fields (columns) into your other feature class by selecting that feature class (or table), going to Data and then Fields (like before) and just doing a Paste. I hope this helps!

[LyonMNGIS]

I recommend that you import the excel table into a Geodatabase first using the table to table geoprocessing tool.