[bullshead]

I too am trying to import a csv file, but size is not the issue, it's interpreting the import parameters.

If I do Ctrl-Shift-M to fire up the import from CSV dialogue, it translates this into

load data infile 'path:filename.csv' into table tblname fields terminated by ',' enclosed by '”' lines terminated by 'rn';

The problem is that I am getting weird results. The CSV is BOG standard eg.

123456,”Mr”,”John”,”Smith”…

but depending on how I tweak the parameters it either imports every other record or something else daft. I have sort of got it to work by getting rid of the enclosing double-quotes, but I shouldn't have to do this.

One question, which I guess I should know the answer to having used PCs since 1981 is where do I find what

t

n

r

all mean?

[Author]

Posts