Exporting and Importing data

You can user OledbConnection string .

the code for import excel :

code:

private DataTable getDataFromXLS(string path, string blad,string headers)
{
try
{
string strConnectionString =string.Empty;
strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source="+path+";" +
"Extended Properties=" + (char)34 + "Excel 8.0;HDR=Yes;IMEX=1;" + (char)34;

OleDbConnection cnCSV =new OleDbConnection (strConnectionString);
cnCSV.Open();
OleDbCommand cmdSelect = new OleDbCommand (@"SELECT " +headers+ " FROM ["+blad+"]", cnCSV);
OleDbDataAdapter daCSV = new OleDbDataAdapter();
daCSV.SelectCommand = cmdSelect;
DataTable dtCSV = new DataTable ();
daCSV.Fill(dtCSV);
cnCSV.Close();
daCSV = null;
return dtCSV;
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
return null;
}
}