Data types - Help

  • Thread starter Thread starter Pastor Andrew Alexander
  • Start date Start date
P

Pastor Andrew Alexander

How do you mach the data type in excell with the data type in access? In
excess I have have for SSN the category as special and type social security
number, ans in Access I have the data type as" number". What can I do to
get them to mach so I can update my records? Also with Zip code and Phone
number in excel and "number" in Access.

Andrew
 
Hi

it is generally accepted that zip code, phone number (maybe SSN, but i don't
use these) are stored as TEXT in Access as you're not performing
calculations with them and might like to store non-numeric symbols (e.g. the
brackets around phone numbers etc) as well. Is there any reason why you
can't change your Access database for these fields to TEXT and then there
won't be a problem.

Cheers
JulieD
 
Back
Top