> If your numbers  in Excel are entered as text  with leading  zeros
they will import to Access as text and keep the leading zeros. If
they are numbers formatted to show leading zeros, I think the
easiest thing to do would be to set the format on your Access
database field with zeros.