Error When Updating the content of Excel File From Code

[Member 4659001]

i updating the content (column F2) of exel sheet with this code this is working fine In My Company LAn. Like i access this code from server And from client Pc I can Update It Using Code Given Below but when i wrote this code at Client server ,And Trying to do the same , it gives the error : Operation Must use an update able Query Code Is given below Protected Sub Call1() Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\OrderHeader.xls;Extended Properties=""Excel 8.0;HDR=YES;""" Dim factory As DbProviderFactory = DbProviderFactories.GetFactory("System.Data.OleDb") Using connection As DbConnection = factory.CreateConnection() connection.ConnectionString = connectionString Using command As DbCommand = connection.CreateCommand() command.CommandText = "Update [OrderHeader$] set F2= 'Used'" connection.Open() command.ExecuteNonQuery() End Using End Using End Sub i need it on urgent basis. Plz ..........

Raghvendra

[Christian Graus]

This code is accessing a local file which is not within your ASP.NET website. You don't have that access, you need for your excel file to be on the server, below the root directory of your web app.

Christian Graus Driven to the arms of OSX by Vista. "I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )