Text field to date field

D

Dan

I am linking an ACT contact file with "DATE" data types,
but the are apprearing as "Character" fields in Access.

How do I import them as "DATE" type fields or convert
them from Character to date type after import/sync with
ACT.

Thanks in advance for any assistance.
 
J

John Vinson

I am linking an ACT contact file with "DATE" data types,
but the are apprearing as "Character" fields in Access.

How do I import them as "DATE" type fields or convert
them from Character to date type after import/sync with
ACT.

Thanks in advance for any assistance.
Click to expand...

Use the CDate() function; or, create a table with a Date/Time field
and run an Append query appending the ACT linked table into the local
Access table. The date value will convert if it's recognized as a
legal date string.
 
Top