Re: Access200: Not all tables copied

[Jose Perez]

The same happens to me i try migrate DB MS acces 2000 to MYSQL 4.1.8

DB acces have 35 tables with data when i finish the migration only 5 tables has data in MYSQL DB

In Bulk Data Transfer Details i found the following...

SELECT count(*) AS num FROM `Proyectos_cambios_abram2`
Transfering data from table Proyectos_cambios_abram2
SELECT `Id_proyecto`, `Analista`, `Grupo`, `Descripción`, `Nivel`, `Periodo_fiscal`, `Auspiciador`, `Contacto`, `Tel_contacto`, `Suplidor`, `Contacto_suplidor`, `Tel_suplidor`, `Peticion_bspr`, `PDM`, `Fec_peticion`, `Fec_comenzado`, `Fec_est_entrega`, `Status`, `Por_completado`, `Comentarios`, `Departamento_Peticionario`, `Fec_est_comienzo`, `Fec_completado_final`, `Aplicativo`, `Fec_usuario_pendiente`, `Fec_ult_cambio`, `Operador_ult_cambio`, `Horas_est_desarrollo`, `Horas_consumidas`, `Sometido_comite_ind`, `Sometido_legal_ind`, `Proyecto_corporativo`, `Tipo_Peticion` FROM `Proyectos_cambios_abram2`
Getting the number of rows of table Proyectos_cambios_ExportErrors
SELECT count(*) AS num FROM `Proyectos_cambios_ExportErrors`
ERROR: The following error occured while transfering data from Proyectos_cambios_ExportErrors
[Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification on column number 1 (Error)
Getting the number of rows of table query_date_parms
SELECT count(*) AS num FROM `query_date_parms`
ERROR: The following error occured while transfering data from query_date_parms
[Microsoft][ODBC Microsoft Access Driver]Restricted data type attribute violation on column number 1 (fromdate)
Getting the number of rows of table semanas
SELECT count(*) AS num FROM `semanas`
Transfering data from table semanas
SELECT `period`, `begin_date`, `descr` FROM `semanas`
Getting the number of rows of table Subgrupos
SELECT count(*) AS num FROM `Subgrupos`
ERROR: The following error occured while transfering data from Subgrupos
[Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification on column number 1 (Subgrupo)
Getting the number of rows of table Tipo_licencias
SELECT count(*) AS num FROM `Tipo_licencias`
ERROR: The following error occured while transfering data from Tipo_licencias
[Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification on column number 1 (Tipo_Licencia_cd)
Getting the number of rows of table Tipo_migracion
SELECT count(*) AS num FROM `Tipo_migracion`
ERROR: The following error occured while transfering data from Tipo_migracion
[Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification on column number 1 (Tipo_migracion_cd)
Getting the number of rows of table Tipo_peticion
SELECT count(*) AS num FROM `Tipo_peticion`
ERROR: The following error occured while transfering data from Tipo_peticion
[Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification on column number 1 (Tipo_peticion