View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michael Daly Michael Daly is offline
external usenet poster
 
Posts: 3
Default Nevermind

FYI

Turns out I was trying to insert a record whose unique
key matched a record that already existed in the database
table.

-----Original Message-----
Hi,

I am using ADO 2.5 in Excel XP to build a recordset from
the rows in my worksheet, then update a DB2 database

with
the recordset's contents. This is something I've been
able to accomplish before in other workbooks, but not
this time.

When my code attempts to execute the ".update" method, I
receive the following error.

Error: -2147217887
Description: Multiple-step operation generated errors.
Check each status value.

This is a new one on me, and I have no idea where to
begin. Any ideas?

Thanks,
Michael
.