Importing and retaining zero value (1 Viewer)

[nonrev1]

I have 8 digit account numbers. I receive my data from another department in Excel which has dropped the 0 from many of these account numbers that begin with a 0. I know that changing the data property to text will prevent this in Access but since the 0 had already dropped prior to import into Access that does not rememdy it. Does anyone know the simplest solution? Can I get Excel to remedy prior to importing into Access? Can I do an update query in Access to add beginning zeroes to all account numbers less than 8 digits?

 

[[nateobot]]

In Excel fi you change the property of the cells to custom and type in "00000000" then it will add 0's to the beginning of the numbers that are less than 8 digits.