Hello,
Does MS Access support the char datatype? I just don't mean strings/text in general, but a fixed length string - vs varchar?
I need to build a loadfile for our health care provider and their fixed format loadfile prefers that certain information start on certain columns. e.g. The first 9 chars are SSN, then the next 25 are for fname, the next 25 for lname...
... the idea is to pad out the remaining characters with blank spaces, having the data values be left adjusted.
Of course I could grab the length of the characters and subtract that from the fields available length, and concat the needed spaces... but... well. I was wondering if I didn't have to.
All I see if the text datatype. Is there something more in Acc2010?
Thanks!
-Matt G.
Does MS Access support the char datatype? I just don't mean strings/text in general, but a fixed length string - vs varchar?
I need to build a loadfile for our health care provider and their fixed format loadfile prefers that certain information start on certain columns. e.g. The first 9 chars are SSN, then the next 25 are for fname, the next 25 for lname...
Code:
123456789FIRSTNAME LASTNAME [end of line]
Of course I could grab the length of the characters and subtract that from the fields available length, and concat the needed spaces... but... well. I was wondering if I didn't have to.
All I see if the text datatype. Is there something more in Acc2010?
Thanks!
-Matt G.