system resource exceeded error

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

Guest

When I import a text file into Access and use some import specifications I
have in place I get a "system resource exceeded" error. I can export a file
I have with the same layout with similar specs and don't get the error. The
only thing I can think of that is different is that on file has packed fields
and the other doesn't. Any suggestions?
 
Is it possible that the packed fields may contain null bytes (i.e.
Chr(0))? Some versions of Access have problems importing text files that
contain nulls.

If so, I think you'll either need to unpack the packed fields before
importing, or else write VBA code to read the file line by line, parse
it into fields and append the new record to your table.


On Tue, 21 Jun 2005 15:38:03 -0700, "M Hernandez" <M
 
Back
Top