Insert one column into another column in another table

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I have two tables we did a massive export of member data
and left out a column(table1), I exported column i need
with key from original source, now how do insert the
column (in a blank existing column) into table1, by the
way each record is unique so I have to match up the
member to the right record in new column.

Make sense ?
i hope someone can help.

Thanks
Jason
 
To the exported table, add the column. (Data will be blank, but the column
needs to be there to receive the data.)

Create an Update query from the Source to the Destination, linked by the
Primary key.

Add the Source Column to Destination Column.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top