79807154

Date: 2025-11-02 13:50:18
Score: 2
Natty:
Report link

As others have suggested, you should really look into OLE automation. It is the easiest way to work with MS Office files in your code.

Anyway, if you want to stick with OleDb and SQL, open an OdbcConnection and use an UPDATE statement. Here is a good starting point on how to do it:

Updating Excel Sheet Using OleDb

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Stefan Lober