OleDbConnection connection = new OleDbConnection();
                connection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + appPath + "\\baza\\bdaccess.mdb;Persist Security Info=false";
                connection.Open();

                SqlConnection conect = new SqlConnection("Data Source=LocalHost;Persist Security Info=True;User ID=db_1;password=passworsmy;Initial Catalog=MyDataBase");
                conect.Open();
                SqlCommand cmd = new SqlCommand("Select ProductName From Products",conect);
                SqlDataReader reader = cmd.ExecuteReader();
                
                OleDbCommand command = connection.CreateCommand();
                while (reader.Read())
                {
                    command.CommandText = "Insert Into product (name) values (@name)";
                    command.Parameters.Add("@name", OleDbType.VarChar).Value = reader.GetString(0);
                }
              
                int rowsAffected = command.ExecuteNonQuery();
                MessageBox.Show("Данные добавлены " + rowsAffected + " запись");
                conect.Close();
                connection.Close();

while (reader.Read())
{
    command.CommandText = "Insert Into product (name) values (@name)";
    command.Parameters.Add("@name", OleDbType.VarChar).Value = reader.GetString(0);
}
не получиться потому что тут только первого значение будет добавлена в базу акссеса 

 using (DataTable dt = new DataTable())
            {
                using (OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + appPath + "\\baza\\bdaccess.mdb;Persist Security Info=false"))
                using (OleDbCommand cmd = new OleDbCommand("Select * From product", conn))
                using (OleDbDataAdapter adapter = new OleDbDataAdapter(cmd))
                {
                    //cmd.CommandType = commandType;
                    cmd.Connection.Open();
                    adapter.SelectCommand.CommandTimeout = 240;
                    adapter.Fill(dt);
                    adapter.Dispose();
                }

                using (SqlConnection conn2 = new SqlConnection("Data Source=LocalHost;Persist Security Info=True;User ID=db_1;password=passworsmy;Initial Catalog=MyDataBase"))
                {
                    conn2.Open();
                    using (SqlBulkCopy copy = new SqlBulkCopy(conn2))
                    {
                        copy.DestinationTableName = "tabels";
                        copy.BatchSize = 1000;
                        copy.BulkCopyTimeout = 240;
                        copy.WriteToServer(dt);
                        copy.NotifyAfter = 1000;
                    }
                }
            }