Text field to date field

  • Thread starter Thread starter Dan
  • Start date Start date
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.
 
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.
 
Back
Top