Ok I think I figured out how to construct the query:
UPDATE ElectricalParts INNER JOIN [SYSADM_PART - Sandbox] ON ElectricalParts.ID = [SYSADM_PART - Sandbox].ID
SET [SYSADM_PART - Sandbox].DESCRIPTION = [ElectricalParts].[Description],
[SYSADM_PART - Sandbox].STOCK_UM = [ElectricalParts].[STOCK_UM],
...(more of similar code)
[SYSADM_PART - Sandbox].IS_KIT = [ElectricalParts].[IS_KIT];
This updates all fields in the SYSADM_PART - Sandbox table with fields in the ElectricalParts where ID is the same in both tables.
When I run the query, though, it's says too many fields defined. When I click Help, it says I have more than 255 fields... but, in fact, I only have 132 fields.
Does anyone have any ideas on how to get this done?
Bookmarks