import table with leading zeros

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

Guest

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