01-06-2009, 02:48 PM
|
 |
Forum Guru
|
|
Join Date: 06 Dec 2006
Location: Mississauga, CANADA
MS Office Version:2003 & 2007
Posts: 18,384
|
|
Ok I think I figured out how to construct the query:
Code:
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?
__________________
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to my reputation by clicking the icon next to the Post # in the bar above my avatar (picture) in this post.
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
|