Need Help

[Sandra8784]

Hi guys..im developing a system by using C# ..my first task would be transfering data from Ms Excel to Ms Access..i couldnt find C# codes for transfer data from excel to access..

private DataSet GetData()
{
try
{
string strConnectionString =string.Empty;
strConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\UserData\\MEIMaintGUI\\SCM@MP\\SCM@MP\\ bin\\Debug\\db1.mdb" ;
OleDbConnection cnCSV =new OleDbConnection (strConnectionString);
cnCSV.Open();
OleDbCommand cmdSelect = new OleDbCommand (@"SELECT * FROM [Sheet1$]", cnCSV);
OleDbDataAdapter daCSV = new OleDbDataAdapter();
daCSV.SelectCommand = cmdSelect;
DataSet dtCSV = new DataSet ();
daCSV.Fill(dtCSV);
cnCSV.Close();
daCSV = null;
return dtCSV;

}
catch(Exception ex)
{
return null;


}
finally
{
}

}

private void TransferData()
{
}

pls help to solve this problem...thanks

[kenobewan]

Here is an article that may help:
Export data from datagrid to Excel