csv and leading zeroes

I'm trying to write the contents of a csv file to a table, but I am having problems with fields with leading zeroes. Whenever I save as csv I lose the leading zeroes. Does anybody know how to prevent this?

I don't know what data type you are using but you can use Decimal and Numeric so you can set precision and scale. Try the link below for details. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms187746.aspx