Import fixed-length file and pad field with spaces

  • Thread starter Thread starter dw
  • Start date Start date
D

dw

Hi. We're pulling in data from a fixed-length file into Access 2003. There's
one field that should be 25 characters always -- padded with extra spaces if
it's less than 25. In other words, it's being pulled in as VarChar but we
need it to be Char of length 25. In addition, there's a field that can be
null; if it's null, we'd like to have it filled with spaces when pulled in.
Your help is much appreciated. Thank you.
 
You can pad those fields, but any editing of those fields will cause
ms-access to automatically trim the fields.

I can't think of ANY POSSIBLE reason to store those extra blanks and waste
space.

If you need to export the data, then appropriate export features allow fixed
length exporting...

so, really, I can't see any need to store the data as fixed...
 
Back
Top