IT Consulting

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

How To: Run Command Prompt as Administrator and execute the following command to stop and remove MySQL service. Net stop MySQL Sc delete MySQL Go to Control Panel >> Programs >> Programs and Features, select MySQL Server 5.x and click Uninstall. (If you can uninstall MySQL from Control Panel) Open Windows Explorer and go to Organize > Folder and search options, Select the “View” tab and under “Hidden files and Folders” choose “Show hidden files and folders”. Now explore the following locations and delete following folders. C:\Program Files\MySQL C:\Program Files (x86)\MySQL C:\ProgramData\MySQL And if exists, delete it too C:\Users\[User-Name]\AppData\Roaming\MySQL Restart your PC and reinstall MySQL. That’s all! Applies To: Windows Server 2008 R2 Windows Server 2008 Windows 7 Windows Vista