Devart Forums

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

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.