public void importdatafromexcel(string excelfilepath)
{
//string ssqltable = "tdatamigrationtable";
//string myexceldataquery = "select id,p_name,city from [medi1$]";
string excelconnectionstring = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=medi1.xls;Extended Properties=""Excel 8.0;HDR=YES;""";
using (OleDbConnection connection = new OleDbConnection(excelconnectionstring))
{
OleDbCommand command = new OleDbCommand("Select id,p_name,city FROM [medi1$]", connection);
connection.Open();
using (DbDataReader dr = command.ExecuteReader())
{
string sqlconnectionString = ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString;
using (SqlBulkCopy bulkCopy =
new SqlBulkCopy(sqlconnectionString))
{
bulkCopy.DestinationTableName = "ExcelData";
bulkCopy.WriteToServer(dr);
}
}
}
Deepak SainiPosted Apr 6, 2015, 8:45 AM
string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path +";Extended Properties=Excel 12.0;Persist Security Info=False";
use this to Excel connection string and check your Excel sheet path.