G
Guest
I am importing data in csv format into a table. The dates are in yyyy/mm/dd
format and I want them to be converted into mm/dd/yyyy format during the
import. Is this possible using validation and if so how is it done? If not,
do I need to import the data as text and then run a query to covert the data,
and how would that query look?
Thanks,
Perry
format and I want them to be converted into mm/dd/yyyy format during the
import. Is this possible using validation and if so how is it done? If not,
do I need to import the data as text and then run a query to covert the data,
and how would that query look?
Thanks,
Perry