Numbers

  • Thread starter Thread starter Super Slueth
  • Start date Start date
S

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
 
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)
 
Back
Top