Error Occurs When using ADO.NET OLEDbDataAdapter to Modify Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
According to the article:
http://support.microsoft.com/kb/316756
At the "RESOLUTION" section - "... To modify existing records, you must
provide primary key information through the UpdateCommand member ..."
What should be added to the code in this article to provide "primary key
information"?
Thank you.
 
¤ Hello,
¤ According to the article:
¤ http://support.microsoft.com/kb/316756
¤ At the "RESOLUTION" section - "... To modify existing records, you must
¤ provide primary key information through the UpdateCommand member ..."
¤ What should be added to the code in this article to provide "primary key
¤ information"?
¤ Thank you.

Did you try the code in the referenced article (using an INSERT statement):

How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET
http://support.microsoft.com/kb/316934


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top