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

Question

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.

LyonMNGIS · Answer

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

AdrianWelsh · Answer

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!

JasonBritton1 · Answer

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.