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
Leading character and zeroes to pad field entries 7
Import Fixed Length Including Spaces 1
Fill Remaining Text Field With Blanks 3
Fixed Length 9
Format fixed length fields with leading zeros or spaces 5
Problem with CHAR type in CREATE TABLE DDL 1

Top