How to get the data from Excel into C#? -


i have c# program takes data excel , saves sql database. when open excel file , run program working if close excel file , try run program again there error like:

an unhandled exception of type 'system.data.oledb.oledbexception' occurred in system.data.dll , additional information=the table not true way.

so how can solve problem?

here part of code errors:

string conexcel = "provider=microsoft.jet.oledb.4.0;" + "data source=\kisiler.xlsx;" + "extended properties=excel 8.0";  string cmd = "select * [sayfa1$]"; oledbdataadapter adp = new oledbdataadapter(cmd, conexcel); dataset ds = new dataset(); adp.fill(ds); 

adp.fill(ds); error part.

what trying opening xlsx file, using older version of oledb provider. try this:

"provider=microsoft.ace.oledb.12.0;" + "data source=kisiler.xlsx;" + "extended properties=excel 12.0 xml"; 

Comments