out of memory error on text file import

[Guest]

I'm trying to load a large file (1.2M records, 235 character fixed length
record layout) into a table in an Access 2003 mdb. Every time I try to use
the text import wizard it uses up a lot of cycles and comes back with an out
of memory error. I've tried to import a few records from a sample file of 10
records and have defined a Data Import specification that works
satisfactorily on the first row, but does not import any of the subsequent
rows in my sample file. Does anyone know how to go directly to importing the
file using my specification (rather than have the wizard try to work it out),
and does anyone know why only the first row is importing?

 

[John W. Vinson]

I'm trying to load a large file (1.2M records, 235 character fixed length
record layout) into a table in an Access 2003 mdb. Every time I try to use
the text import wizard it uses up a lot of cycles and comes back with an out
of memory error. I've tried to import a few records from a sample file of 10
records and have defined a Data Import specification that works
satisfactorily on the first row, but does not import any of the subsequent
rows in my sample file. Does anyone know how to go directly to importing the
file using my specification (rather than have the wizard try to work it out),
and does anyone know why only the first row is importing?

I'd suggest trying a different tack. Compact the database first so you're not
pushing the 2 GByte limit; *link* to the text file using the import spec,
rather than importing it directly. Then run an Append query to populate the
local table.

John W. Vinson [MVP]