Yovanys 0 Newbie Poster

Excuse my English..

At work we have porting some app to MySQL, but there are still some Database in Access 2.0, Access 97, DBF, etc

Some important database is "codifica" is in access 2.0, this DB contain to many tables that are used in other DB.

I need copy data from Access to MYSQL
I Have the same schema in MYSQL as in Access for the tables I need to import.

I use the following code to import data from access to mysql in a simply way.

1.
      public void Importar()
   2.
              {
   3.
                  foreach (string tabla in tablas)
   4.
                   {
   5.
                      DataTable codificaDataTable, mySqlDataTable;
   6.
                      creoTablas();
   7.
                      caminoCodifica = GetCaminoCodifica();
   8.
                      codificaCnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + caminoCodifica;
   9.
                      SqlStr = "SELECT * FROM " + tabla;
  10.
                      codificaAdapter = new OleDbDataAdapter(SqlStr, codificaCnn.ConnectionString);
  11.
                      codificaAdapter.AcceptChangesDuringFill = false;
  12.
                      codificaCnn.Open();
  13.
                      codificaDataTable = new DataTable();
  14.
                      codificaAdapter.Fill(codificaDataTable);
  15.
                      codificaAdapter.Dispose();
  16.
                      if (codificaDataTable != null)
  17.
                      {
  18.
                          tabla1 = tabla + "1";
  19.
                          SqlStr1 = "SELECT * FROM " + tabla1;
  20.
                          mySqladapter = new MySqlDataAdapter(SqlStr1, mySqlcnn);
  21.
                          mySqlCmdBuilder = new MySqlCommandBuilder(mySqladapter);
  22.
                          mySqladapter.InsertCommand = mySqlCmdBuilder.GetInsertCommand();
  23.
                          mySqladapter.Update(codificaDataTable);
  24.
                          mySqladapter.Dispose();
  25.
                          mySqlCmdBuilder.Dispose();
  26.
                          codificaDataTable.Dispose();
  27.
       
  28.
                      }
  29.
                     
  30.
                  }
  31.
              }

But I need to copy not all data, but just data (Rows) present in Access that are not present in MySQL.

Any Suggestion????