Import from Excel -- Leading zeroes disappear

  • Thread starter Thread starter Thomas
  • Start date Start date
T

Thomas

Hello all,

I work for a phone company and twice a month I get a
report with several number ranges, in a excel spread
sheet. For example: 123 456 0000 9999
This shows that the company owns all the numbers in a
specific areacode and prefix.

What I want to do is import this into Access, and I do so
by selecting: Import External Data. Select my file,
choose first column to be my headers, paste into a new
table (where the preview shows all the leading zero's)
and then click finish. But when I look at my imported
data in the query, my data has changed to 123 456 0 9999.
Same thing happens with foreign area dodes like 012, it
will strip the 0.
Is there any way I can make access just take my data as
it is, and quit messing with it?

Thanks,
Tom
 
You want the field you're importing from Excel to be formatted as text
datatype. If it's numeric you'll drop leading zeros.
 
Back
Top