When trying to export using the Export Wizard the following error occurs:
Not a legal OleAut date. Export is cancelled.
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.
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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center