Exporting leading zeros

  • Thread starter Thread starter MS news
  • Start date Start date
M

MS news

Can someone help with the following...

I am trying to export SSN to a fixed lenth export file. A SSN like
009-999-9999 exports as 9999999. I see the SSN as 0099999999 in my query
just like I want it exported.... but Access drops the zeros in my txt file.
I have tried formatting SSN as a number and as text. What should I do in my
query or export specs to fix this problem? Thanks in advance for you help.
 
Your SSN field should be text in your database. Then it should export
exactly as it's stored.

If you can't change it, your query should use the Format function to convert
it to text, and then it should export properly.
 
Back
Top