Updating a column

[Payal Patel]

Hi,
I have file that is importing social security numbers to access. It is coming in aas a text.However dropping a zero if it has a zero in front of it - for example "012345678" is coming through as "12345678". Is there a way I can update the socials with the zeroes in front?

Thanks in advance,
Payal

 

[Galaxiom]

It should not drop the zero if the field type is set as Text in the destination.

If there are always nine characters you can format with this:
Format([fieldname], "000000000")