Import data from Excel sheet to sql Database-asp.net 2.0

[Member 4659001]

Currently I need to write a code To Import data from Excel sheet to sql Database-asp.net 2.0 I Have Written A function For It Function Is Given Below ; But as i execute it it gives Error Meaasge "The Microsoft Jet database engine cannot open the file 'D:\'. It is already opened exclusively by another user, or you need permission to view its data." I Have Order.xls File In D Drive protected void btnUpload_Click1(object sender, EventArgs e) { string PathtoTextFile = ("D:\\"); Response.Write(PathtoTextFile); System.Data.OleDb.OleDbConnection oCon = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\;Extended Properties= \"Excel 8.0;HDR=no;IMEX=1 \""); System.Data.OleDb.OleDbDataAdapter oCmd = new System.Data.OleDb.OleDbDataAdapter("select * from Order.xls", oCon); DataSet myDS = new DataSet(); oCmd.Fill(myDS); oCon.Close(); }

Raghvendra

[Greg Chelstowski]

You need to pass the filename in the data source, in the connection string, dude. You're on the right path, though. And then, the sql you wrote ("select * from Order.xls") should really be ("select * from Sheet1"), or whatever your Sheet is called in that excel spreadsheet. The rest seems fine... Except I would use a DataTable, and not a DataSet. Easier that way ;)

var question = (_2b || !(_2b));

[Member 4659001]

Thanks For Reply, I did the same as u instructed , But Still Having Same Error

Raghvendra