Velocity Reviews - Updating Excel Spreadsheet Through ASP.NET

Hello Everyone,

I am encountering quite an unusual sort of problem while updating my Excel spreadsheet from an ASP.NET application. Basically I have an excel worksheet (Sheet1$) that contains contact information. Two columns are totally blank and I want to update all rows in that column with a single value. I am currently using the following code to perform this action...

Connection String:

Code:

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties=\"Excel 8.0;HDR=YES\"";

Code to Execute Query:

Code:

 

OleDbConnection conn = new OleDbConnection(strConn);

conn.Open();



string sql = "UPDATE [Sheet1$] SET List_Name='" + listName + "' AND Active='" + active + "'";



OleDbCommand cmd = new OleDbCommand(sql, conn);

cmd.ExecuteNonQuery();

The code itself executes just fine, but when I go back into my excel spreadsheet to see if the data has been updated, all the rows in these columns are still blank. I have attempted to fix this doing the following:

A. Checked file permissions on the directory and the file itself.
B. Added some extended properties to the connection string (ReadOnly, Mode=ReadWrite) with no change in results.
C. Tried updating a single record but the column row still remained blank.
D. Debugged to make sure the variables listName and active had values (they did)

If any of you have some insight on this please let me know. Thanks in advance.