Character Length with Fixed Length Imports

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

Guest

I am trying to import goverment data from a fixed length file. When I am
importing data the last field cuts off at approx. 600 character. Is there a
max. row/import length that can be imported? I could not find this via
online help.
 
Hi Jim,

There's a limit on the length of a line that can be imported but it's
quite long and you're far more likely to have hit the limit on the
number of characters per record in an Access table. This is nominally
2000 characters, in practice usually rather more because of the way
Unicode compression works.

There are two ways of getting round the limit. One: most wide text files
can be normalised into two or more narrower tables. Two: replace one or
more of the wider text fields with memo fields, whose contents aren't
included in the 2000 character limit.

On Mon, 9 May 2005 11:05:09 -0700, "Jim DeAngelis" <Jim
 
Back
Top