importing data from an excel sheet to sql server express using c#

[Narz1986]

hi....i m fairly new to c#.net...i m trying to import data from an excel file to sql server using c#.....below here is my code....when i m executing this code i m getting an exception "ODBC CALL FAILED" i m not able to figure out where i hve gone wrong...so if any one could guide me i wil b thankful....




private void Import_btn_Click(object sender, EventArgs e)
{
try
{
string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + openFile.FileName + ";Extended Properties=Excel 8.0";
// Create Connection to Excel Workbook
OleDbConnection connection = new OleDbConnection(excelConnectionString);
connection.Open();
OleDbCommand command = new OleDbCommand("INSERT INTO[ODBC;DRIVER ={SQLEXPRESS};SERVER=DASSDP-12\\SQLEXPRESS;DATABASE=mIO;Trusted Connection=Yes].Brand SELECT Brand FROM [BrandDefinition$A8:E9999]", connection);
command.ExecuteNonQuery();
connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
}

}

[akshaycjoshi]

OleDB provider for MS excel ?
Dont think it will work, i guess u will have to use System.IO or Excel library for that.

[Narz1986]

yes Oledb provider for excel.......
could u tel me if there is any other method.....