LOAD DATA INFILE 'path-to-file' INTO TABLE table FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n'; </pre><BR><BR>The user running it must have the file privilege. If you just need to do this once, ...