Import fixed-length file and pad field with spaces

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.
 
A

Albert D. Kallal

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...
 

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

importing 4,000 fixed field length records - parsing - removingspaces - etc 3
Exporting Fixed Width Text File 4
Import Fixed Length Including Spaces 1
Leading character and zeroes to pad field entries 6
Fill Remaining Text Field With Blanks 3
Fixed Length 9
Pad field length 6
Count field length in delimeted file and compare with predefined listof field length 8

Top