Question: how to import excel data into oracle table using asp net?
Answer: string xConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server. ...  "Extended Properties=Excel 8.0;"; using (OleDbConnection connection = new OleDbConnection(xConnStr)) { OleDbCommand command = new OleDbCommand("Select * FROM [Sheet1$]", connection); connection. ...  // Create DbDataReader to Data Worksheet.