Problem Importing CSV files into Mysql Database
Jan.31, 2008 in
Tech
Today I spent sometime trying to import data which originated in an Excel File into a table in my Mysql database using the import interface provided by phpMyAdmin. I kept receiving error messages due to a column mismatch in the first row of the data. After trying many different solutions, it turned out that the way to solve it was to use tabs as field delimiters instead of commas, and this fixed the problem!

Leave a Reply