Return
-
Title
Error, "Not a legal OleAut date. Export is cancelled" when trying to export in Export Wizard -
Description
When trying to export using the Export Wizard the following error occurs:
Not a legal OleAut date. Export is cancelled.
-
Cause
Imported data as a new table and Toad automatically selected a column to be TIMESTAMP(6) when original datatype was NVARCHAR(50).
Example: Table1 had a column called DOB as a NVARCHAR(50) with data looking as 5/23/81, then performing an import as a new table based on a query casued Toad to automatically select a TIMESTAMP(6) for the DOB column converting the data found to be 05/23/0081.
-
Resolution
Ensure the datatypes match from source when importing or exporting data or when creating new tables from original tables. Any mis-match of datatypes can causes issues during imports and exports.