Hi,

I am using Access 2000 and am trying to import a TXT file that is
Fixed Length.

IT appears when reaching the Access database it is cutting out some of
the characters. IF the fiel says "00000" it is going into Access as
"0".

IS there anyway to preserve all the characters?

Yes, you can modify and save the import specification. Obviously, you want
the zeros saved as text, not numeric, because as a number 0 and 00000 are
identical, just formatted differently. I don't do text imports often enough
to be able to give much detail, but you can try working with the import
spec.

On the other hand, if none of the entries in that field include alphabetic
characters, you could (1) simply use them as the numbers they are and use a
format to show leading zero's when you display or print, or (2) you could
use a Query that saves them into a different, text column, and convert if
necesary.

Larry Linson
Microsoft Office Access MVP

"bcap" <rayh (AT) patriots (DOT) com> wrote