import table with leading zeros

D

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?
 
J

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.
 
Top