Invalid Argument / Argumento no válido (Ingles/Español)

[Carolina Rosario]

I import data from Informix to Access, used the dodbc
driver informix version 3.30.000.

While import data the cause the error : "Invalid Argument"
and stop process.

The table import contained 53 columns and 2387053 records.
I used Microsoft Office XP, MS Access 2002 and the format
file mdb is 2000 and testing with 2000 so.

Thanks for help me.
Sorry my english, is bad.

-----------------------------------------------------------
Cuando importo una tabla desde Informix a travès de ODBC
(driver informix 3.30.000) a una base de datos Access
obtengo el siguiente error: "Invalid Argument"

La Tabla a importar posee 53 columnas y 2387053 registros.
Estoy utilizando Office Xp, Access 2002 y el formato del
archivo mdb es 2000 y 2002, he probado con ambos.

Agradezco la ayuda.

 

[Dirk Goldgar]

I import data from Informix to Access, used the dodbc
driver informix version 3.30.000.

While import data the cause the error : "Invalid Argument"
and stop process.

The table import contained 53 columns and 2387053 records.
I used Microsoft Office XP, MS Access 2002 and the format
file mdb is 2000 and testing with 2000 so.

Thanks for help me.
Sorry my english, is bad.

-----------------------------------------------------------
Cuando importo una tabla desde Informix a travès de ODBC
(driver informix 3.30.000) a una base de datos Access
obtengo el siguiente error: "Invalid Argument"

La Tabla a importar posee 53 columnas y 2387053 registros.
Estoy utilizando Office Xp, Access 2002 y el formato del
archivo mdb es 2000 y 2002, he probado con ambos.

Agradezco la ayuda.

I'm just guessing, but it may be that you've simply exceeded the
capacity of an Access .mdb file. The maximum size of an Access database
file is 2GB, so if you're importing 2 million records, each record (with
its related overhead) would only need to require 1000 bytes in order to
make the whole file too big to handle. On top of that, there's bound to
be overhead in the import process itself that could cut into the space
available for the imported table.

What happens if you try to import, say, half as many records?

 

[Van T. Dinh]

Your English is much better than you think!

Besides the possibility of going over the 2 GB limit of an Access database
(actually, it is more likely the 1 GB limit on the Table size) as Dirk
mentioned, try trapping the ODBC error Messages and see what you can come up
with.

See the Microsoft KB article on how to trap ODBC error message:

http://support.microsoft.com/?id=209855

--
HTH
Van T. Dinh
MVP (Access)



I import data from Informix to Access, used the dodbc
driver informix version 3.30.000.

While import data the cause the error : "Invalid Argument"
and stop process.

The table import contained 53 columns and 2387053 records.
I used Microsoft Office XP, MS Access 2002 and the format
file mdb is 2000 and testing with 2000 so.

Thanks for help me.
Sorry my english, is bad.

-----------------------------------------------------------
Cuando importo una tabla desde Informix a travès de ODBC
(driver informix 3.30.000) a una base de datos Access
obtengo el siguiente error: "Invalid Argument"

La Tabla a importar posee 53 columnas y 2387053 registros.
Estoy utilizando Office Xp, Access 2002 y el formato del
archivo mdb es 2000 y 2002, he probado con ambos.

Agradezco la ayuda.