excel connection string

hi every body

I try to check excel file on my check i make connection string

why it cant read ConnectionString varible and gets me error ??

this my code

string excelexc = DropDown.SelectedValue;

string fileexc = Path.GetExtension(excelexc);

string ConnectionString;

string path;

switch (fileexc)

{

case ".xls":

path = Server.MapPath("~/Schoolresult/" + DropDown.SelectedValue);

ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + path + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'";

break;

case ".xlsx":

path = Server.MapPath("~/Schoolresult/" + DropDown.SelectedValue);

ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=\"Excel 12.0;ReadOnly=False;HDR=Yes;\"";

break;

}

OleDbConnection connExcel = new OleDbConnection(ConnectionString);

OleDbCommand cmdExcel = new OleDbCommand();

try

{

//my code goes here on connection string kind

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Francis Susaimichael10y ago
Is it your problem solved? If not, please add some more details on your problem
0
MR alaa10y ago
thanks the answer is
String ConnectionString = "";
0

Vignesh Mani10y ago

String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + 	"Data Source=" + Server.MapPath("../ExcelData.xls") + ";" + 	"Extended Properties=Excel 8.0;";

Try Above One