Importing problem with phone numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChuckW - 31 May 2006 21:20 GMT

Hi,

I have an excel file with phone numbers. Some are international. It is a
text filed in Excel. Whenever I import them into Access, access changes them
into an exponential number. When I reimport them back into excel from access
it stays as an exponential number which is a problem. Is there a way to
avoid this and keep the field as is?

Thanks,

Signature

Chuck W

Reply to this Message

Kelvin Middleton - 31 May 2006 21:34 GMT

I'd recomment that you first design a table within Access and specify the
telephone number field as text, so when you import the worksheet Access
doesn't alter the number by removing preceeding zero's etc..

This should then also mean when you export or copy/paste back into Excel
your number should be the same as when it was first imported.

Kelvin

> Hi,
>
[quoted text clipped - 7 lines]
>
> Thanks,

Reply to this Message