This is a migrated thread and some comments may be shown as answers.

Download Excel sheet issue

0 Answers 64 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
NA
Top achievements
Rank 1
NA asked on 18 Mar 2015, 12:04 PM
Download excel sheet  i got the below exception 

System.Data.OleDb.OleDbException (0x80004005): Operation must use an updateable query. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at in asp.net


I am using the  "sql = "Insert into [Data$]",connection  
MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + destPath + "';Extended Properties=Excel 8.0;");

Please help me 

No answers yet. Maybe you can help?

Tags
General Discussions
Asked by
NA
Top achievements
Rank 1
Share this question
or