system resource exceeded error

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?
 
J

John Nurick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error: System Resource Exceeded 2
Importing Text file with Strange Delimiter 1
System Resource Exceeded 1
System Resource Exceeded 5
how do i resolve the 'system resource exceeded' error? 6
Import specification errors 1
RUN TIME ERROR 3035 System Resource Exceeded 1
"Maximum Number of fonts exceeded" 2

Top