I have an speadsheet file contains some data such as ID, name, lastname. Can I import excel file to phpmyadmin (SQL)? How to do it?
A:
Export the spreadsheet as CSV first, then import as CSV.
Ignacio Vazquez-Abrams
2010-05-10 15:07:36
I do it but it doesn't work for me.
Giffary
2010-05-10 15:09:44
... And you honestly expect us to figure out what the problem is with "doesn't work"?
Ignacio Vazquez-Abrams
2010-05-10 15:11:39
It show me "Invalid field count in CSV input on line 1."
Giffary
2010-05-10 15:16:35
Did you look in the file to see if that's true?
Ignacio Vazquez-Abrams
2010-05-10 15:18:34
I my file, I have two column (ID, name). And in phpmyadmin I build table 'test' that have two column (ID, name) too.When I import .CSV file to phpmysql it show 'Invalid field count in CSV input on line 1.'
Giffary
2010-05-10 15:26:04
Maybe the name contains an unescaped comma? Or you've got your separators mixed up (ie. different separators in the file and in the import settings)?
Lex
2010-05-11 11:12:10