Migrating Data between two Tables

JTS25

New Member
Joined
Oct 10, 2019
Messages
31
HI all,

I am working in a Table named ' Initiative Status', and this Table has two fields that hold comments ' Status Comments' & 'SOW Comments'. We have been told that the field 'SOW Comments' is being removed, and I have been asked to move all of the information that was in 'SOW Comments' into the 'Status Comments' field.

There are around 600 rows in this Table, that have 'SOW Comments' associated to them. Is there a way to do this migration, without having to work each item individually? Any help is greatly appreciated.
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Take a look at doing an Update Query.

You want to set the Criteria to update all record where the "SOW Comments" field is not empty, and you want to update the "Status Comments" field to be the combination of the two fields.

The SQL code of the query might look something like:
VBA Code:
UPDATE YourTableName 
SET [Status Comments] = [Status Comments] & [SOW Comments]
WHERE [SOW Comments]<>"";
 
Upvote 0

Forum statistics

Threads
1,225,360
Messages
6,184,508
Members
453,237
Latest member
lordleo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top