<B>Leading Zero Problem</B> 1

[Dutt]

I'm importing data into an Access 2000 database from Excel 2000(comma delimiter Text File). The problem I'm having is that my field customer ID 0010002 when importin into access it chages it to 10002. I've tried ever datatype. If anybody knows anything that will keep the zeros let me know.

Thanks for the help!

Dutt

 

[jebry]

Hi!

After you import the data, if you go to the table and change the input mask to social security number, I think it will put in the leading zeros. At least it worked that way for me. If it doesn't work you can do an update query where you choose the field in question and in the update to put format([fieldname],"000000000&quot.

hth
Jeff Bridgham

 

[Dutt]

Thanks Jeff,

It seem to have worked great. Thanks I really appreciate it!

Dutt