Data types - Help

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

"Pastor Andrew Alexander" <pastorandrew@livingtestimonyfellowship.org> wrote
in message news:O8OtGMYFFHA.3416@TK2MSFTNGP09.phx.gbl...
> 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
>
>