Is there a file size limit when importing a fixed length file?

[BobStrawn]

I am trying to import a fixed length file into Access 2002. The file is 300MB
and contains about 300,000 records. When I go through the import process only
the first 65536 records appear in the table?

Last month I imported a 283MB with 217,000 records with no problem. This
month it won't work.

Any ideas?

Thanks,

Robert Strawn

 

[John Nurick]

Hi Robert,

There are various possible causes, including:

* a glitch in the file, e.g a carriage return in the data or a line with
the wrong number of characters. Is there something odd at about line
65536?

* the import is causing the size of your mdb file to hit the 2GB limit.
If the file is in the 1GB range when you start this could easily happen.
Reduce the chance of this problem by
-compacting the database before importing
-removing all or most indexes from the table before importing,
and re-creating them afterwards
-using text file tools to reduce the size of the big file, e.g.
by normalising it into two or more files, cutting out fields
you don't want, splitting it into several pieces which you can
import individually,