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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top