Saturday, November 24, 2007

Import excel file into mysql database - MySQL

Import excel file into mysql database - MySQL: "LOAD DATA LOCAL INFILE 'e:\\sydnet2\\_info\\curdocs.csv' INTO TABLE pnp_docs_current FIELDS TERMINATED BY ',' ENCLOSED BY ''' LINES TERMINATED BY '\n';"

No comments: