fixed width importing problems

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Is there a maximum number of fields you can set in a
fixed width import specification?

I'm importing a text file which is 408 characters wide,
containing 47 columns of data. I've created a spec that
can accomodate importing 41 columns, up to column 348 in
the text file, but can't get it to do any more columns.

i don't think it's the width of the text file that's the
problem - is there meant to be a limit to the number of
columns you can import?
 
There is a limit of 255 fields.
There is also a record size limit (each row of data) of ??2KB?? (Double
check that one.)

Be sure each row of data ends with a vbCRLF. Chr(13) & Chr(10)
Else Access tries to read the entire file as 1 row of data.
 
Back
Top