How to Upload Data to MySQL From an Excel Spreadsheet via MyPhpAdmin on Blue Host
Preliminary Stuff
To boost your prospects of everything working, do an Export to a CSV File first -- and use this as the template into which you load the data to go into the MySQL Tables:
Instructions .....addin the EXPORT stuff
CRITICAL
In Excel you must Save As .csv (Comma Separated Values) -- use the drop down list on the Save As dialogue to find it -- the upload will NOT work if you use a standard Excel format spreadsheet.
Set your primary key field to 0 -- you must have something in this field otherwise the import will think there is no field there, and shift all the columns 1 column to the left -- the AUTO Increment feature will generate new Primary keys for each field -- so don't freak out about them all being zero in the spreadsheet.
In MyPhpAdmin
Get to the page where you can Browse, Import Export etc,
- Choose IMPORT
- Choose CSV using LOAD DATA
- Tick Use LOCAL keyword
- Change Fields Terminated By from ; to , (THAT IS A COMMA!!!) [Because the file is a Comma Separated Value file -- and if you tell the import to go looking for semi-colons as the separators, the import will fall flat on its face]
- Then Press Go (bottom of the Box)