Saturday, April 14, 2012

How to upload excel file to MYsql server

Save your spreadsheet as a CSV (comma separated value) file.
>|
>| After I save the spreadsheet as a CSV file how do I import the data
>| into a MySQL table?[/color]

Look under the Load Data instruction. I use the following:
LOAD DATA LOCAL INFILE 'e:\\sydnet2\\_info\\curdocs.csv' INTO TABLE
pnp_docs_current FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES
TERMINATED BY '\n';