how to get excel data to ms access

try this :
   System.Data.OleDb.OleDbConnection MyConnection ;
    System.Data.DataSet DtSet
    System.Data.OleDb.OleDbDataAdapter MyCommand ;
    MyConnection = new System.Data.OleDb.OleDbConnection("Connection String"); 
     // put our connection string on the place of "ConnectionString" for more information of excel connection string try this link:  http://www.connectionstrings.com/excel
       //and suppse that Sheet1 is your spreadsheet name

    MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", MyConnection);
    MyCommand.TableMappings.Add("Table", "TestTable");
    DtSet = new System.Data.DataSet();
    MyCommand.Fill(DtSet);
    MyConnection.Close();

now you can save dataset in to access database easily.
 
thanks
 
mark as answere if you like my answere