importing data

  • Thread starter Thread starter garry
  • Start date Start date
G

garry

when importing data from a text or excel document into
an access table, i'm lossing the leading zero, any ideas
 
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.
 
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.
 
Back
Top