Import from Excel -- Leading zeroes disappear

[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

 

[Guest]

I found the answer on my own...
There was a problem in the excel file..

 

[Rolls]

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