Importing from CSV

[djsampat]

Hope this helps anyone having any format issues with number columns after importing data from a csv file.

The data was being imported as text instead of numbers and I even tried using num(column) as number and it still did not work.

I realised that you need to turn off "Quoting" and select the "Ignore EOF box"

In the file wizard, check the Ignore EOF box and set Quoting to "None".

It should end up looking like this:-

CSVData:

LOAD

*

FROM

File.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', no quotes, no eof);