Having problems importing an excel column filled in by the now() formula into Oracle.
It is not possible to import this column as a date as Toad for Data Analysts does not understand the now() formula.
All the workarounds found require to copy the data in excel and do a "paste special" selecting "values". Then it is possible to copy the value.
It is possible to skip the "paste special" step?
WORKAROUND
It is not possible to skip the "paste special" step
STATUS
Enhancement request ST 86782 has been submitted to Development for consideration in a future release of Toad for Data Analysts