Toad 13.1 - Error while importing CSV files

Toad for Oracle
1

Hi guys,

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?

Thanks,
Marius

2

can you build small sample file for me so I can test it?

3

Thank you for the quick reply.

The table code below.

CREATE TABLE MY_TABLE
(
DAT_REPORTING DATE,
TXT_NAME VARCHAR2(50 CHAR),
AMT_AMOUNT NUMBER
);

The data sample also below
File MyFile.txt (250 Bytes)

I use Toad 13.1.0.78

Thanks,
Marius

4

It worked OK for me. My windows (and Toad) settings also have ‘.’ for decimal separator and ‘,’ for thousand separator. Are yours different? Maybe that is causing it (if so, it’s a bug)

5

Ah yeah, that’s it. Toad seems to be looking at the overall Toad settings for decimal and thousand separator (in Options -> General) instead of those in the import settings.

Fixed for next beta.