Toad World® Forums

Where can I specify the field data types for a csv connection?


#1

Where can I specify the field data types for a csv connection? I’m guessing the connection process only looks at x amount of rows to guess the data types. Another ETL product I used to use gives the option to look at x amount or look at all. With the all option, there is an option to STOP for when the files are large.

Anywho, I can’t find anywhere that lets me specify the data type. The wizard is guessing wrong.


#2

Are you using import wizard? We don’t have option to change the x amount of rows to guess the datatype, but you can type whatever data type in the select target page, which is more flexible. Let me know if it works for you.

ImportToNewTable.jpeg