Numbers

[Super Slueth]

Hello


I'm trying to import a .csv file into access. The file contains phone
numbers. How can I stop access from changing their format to
scientific.

I'm importing them as a "signle" I don't want them as text value as I
need to do queries on ranges of numbers.

I've tried everything I can think of but access insists on treating
them in scientific format

Any sugestions

 

[Douglas J. Steele]

Telephone numbers should be imported as text. There's nothing stopping you
from using Between with text.

Have them as text also gives you the flexibility of being able to use wild
cards when doing your lookups, so that you can find, for instance, all phone
numbers in the 446 exchange as Like "446????" (or Like "(???) 446-????" or
whatever format you're using to store them)