LOAD DATA LOCAL INFILE -> Exception: Not supported field count found

[JimJones]

Hi!

i try to import a .csv file into a mySQL Database using the mysqldirect component. Ihave a DataSet and created a TableAdapter which contains a SQL Statement like

LOAD DATA LOCAL INFILE 'C:\test.csv' INTO TABLE `testimport` FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n'

If i use this Statement for example in phpmyadmin it just works fine.. I can't figgure out why I searched a lot in this and other forums but i couldn't find somebody with the same problem...

please help me

Jim

[Alexey]

You are using direct mode, aren't you? Unfortunately we do not support this SQL statement in direct mode. You should use client (Direct=false) mode instead.