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';