missing zeros when importing from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when I import excel into Access 2003, the leading zeros are missing.
example 015-201-802 in excel shows up in Access as 15201802 with the first
zero missing
 
Danny

If Access believes that what it is importing is a number, then leading zeros
are dropped (00001 and 1 are the same number).

If you need to import the field as "text", you'll need to import into a
table that has a text field defined to hold that.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Back
Top