May 1, 2011

Connection String for reading data from Excel in ASP.Net

String connString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + excelFile + ";" + "Extended Properties='Excel 8.0;HDR=YES;ImportMixedTypes=Text;IMEX=1';";

No comments:

Post a Comment