For better or for worse, I often have information in one table that I need to transfer to another table. Usually, the two tables have some fields in common, but some unique fields; which means Ctrl-C, Ctrl-V does a column-wise copy of the date, when, in fact, the columns usually don’t match. What does match, however, are the field names. “First Name” = “First Name”, “Last Name” = “Last Name”, etc.
I’d love to have an optional copy that ignores columns and matches field names when copying the data. Any fields that don’t match don’t get copied.
... View more