I have a C# program that takes some data from Excel and saves it to an SQL database. When I open the Excel file and run the program it is working successfully but if I close the Excel file and try to run the program again there is an error like:
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll and Additional information=The table is not true way.
So how can I solve this problem?
Here is the part of my code that errors:
string conexcel = "Provider=Microsoft.Jet.OleDB.4.0;" + "Data Source=\kisiler.xlsx;" + "Extended Properties=Excel 8.0";
string cmd = "SELECT * FROM [Sayfa1$]";
OleDbDataAdapter adp = new OleDbDataAdapter(cmd, conexcel);
DataSet ds = new DataSet();
adp.Fill(ds);
adp.Fill(ds); is my error part.