Maybe a (very) stupid question - I am using Toad 13.1 to import some CSV files with numbers. The separator of the file is comma. The numbers don’t have thousand separators and decimal point is represented by dots.
I set-up everything properly but Toad is interpreting the decimals to integers - e.g. instead of 0.567 it imports 567.
Any ideas what am I doing wrong?