import table with leading zeros

[Dan Connors]

I am trying to import an excel spreadsheet into an Access table. In Excel, I
have the column formatted for "Text" so I can have leading zeros.

When I bring it into Access, how can I keep the leading zeros if I am
importing the data into an existing table?

 

[John Nurick]

Hi Dan,

Either format the Access field and/or the controls that display it to
use leading zeros (e.g. a format string of "00000") - or else use a text
field in your Access table.