getting file contains no data on 2.9GB file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text file that I am trying to import that is 2.9 GB. When I try to
import it I get the error "File 'filename' does not contain data". What would
cause this? My first thought is there is a limit on the size of file I can
import. Anyone know what that is? I am using Access 2003 (11.6566.6568) SP2.
 
As far as I can remember the text file import and linking routine is
unable to read files larger than 2GB. In any case the maximum size of
an Access database file is 2GB.

Usually, these big text files contain huge amounts of redundant nature
and it's only necessary actually to import comparatively small amounts
of it. So the best thing is to use text file tools (e.g. Perl and/or
the Unix utilities at http://unxutils.sourceforge.net/) to filter the
data you need into a file that's small enough to import.
 
Back
Top