Hi everyone.
I am trying to insert data from an excel file into a table (trying to create Orders table from the Oracle OE Schema) using Import Wizard.
Following the solution provided in this thread, I first converted the numeric values to a text using Excel's Text to Columns function, (eg 44850.6540972222 becomes 16/10/2022 5:41:54)
The I right click on the table to import data to get into Import Wizard, in step 4. Column Definition, for the column ORDER_DATE, the format I put down is “DD/MM/YYYY HH24:MI:SS”. (Note there are two spaces after YYYY to match exact how it is in excel, excel put two spaces after YYYY after converting to text for some reason). From what I can see, the format I put down matches exactly the format in excel.
After click “Finish” in Import Wizard, I get the following error. It says ORDER_DATE null.
so I am stuck here.
I have attached the script I used to create Orders table and the excel file with converted date in text format if you need it to help me solve this issue.
Thank you in advance.
orders2.xlsx
Table DDL - ORDERS.txt