Hey,
So I'm using the new data load wizard and it doesn't allow me to change the column data type before create/insert.
I'm importing data with a text field that is all numerical, but has variable fixed length with zeros on the left (that matter and need to be there). So the import wizard will lose data on 1000's of rows which is unacceptable.
The data load wizard insists on this column being number and I can't find a way to change that. I even added a dummy row as the first row with only alpha characters, but the wizard still insists on number since the majority of the rows are numeric in nature.
Is there any way to change the data type in the new wizard or do I just need to pre create the table and use the legacy wizard in "Load to existing table"?
Regards
Olafur