Text field to date field

[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.

 

[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.

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.