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.