There are not enough columns to match the value list.

Message Text

There are not enough columns to match the value list.

Explanation

An UPDATE or INSERT statement contains more values than the table being updated.

Action

Verify your SQL statement to make sure the number of columns matches the table.

See Also
Adding Data UPDATE
Changing Data Using the Select List
INSERT  

 

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.