importing data

G

garry

when importing data from a text or excel document into
an access table, i'm lossing the leading zero, any ideas
 
G

Guest

During imports, Access makes a guess based on the first
couple of records of data as to what the data type is. In
cases of numbers where the leading zero is critical such
as SSN, if Access thinks the data in that field is
numeric, then it will drop the leading zero thinking it is
not needed. To get around this, change the field to text
during the import process.
 
J

johnsni1

If you haven't already received an answer:

The Access Field needs to be formatted as a "text" field
to import the the characters from the excel file correctly.
 
Top