Tuesday, February 28, 2012

Importing from Excel into myphpadmin

Have an excel file with the information. The excel file cannot have any additional information like labels or headers.


Save the file as
CSV
(MS-DOS)

In myphpadmin
select import
browse to the file
uncheck the box for partial import (we don't want a partial import)
change 'Fields terminated by' to a comma.