Msg#: 3193683 posted 8:05 pm on Dec 19, 2006 (gmt 0)
Hello all, I am trying to import a .csv file (converted from excel) into a database with phpmyadmin. My error is #1064 at line 1. I looked up the error and this is what it is: Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR)
Anybody know what this means? Any help appreciated. Steve
Msg#: 3193683 posted 12:36 pm on Dec 20, 2006 (gmt 0)
Seems like there is a latent problem with that function To be honest I tried it a few times and always ended with an error (CSV or XL). I bought for just very few $ a nice little tool that does very well the job.
Msg#: 3193683 posted 6:37 pm on Dec 20, 2006 (gmt 0)
I exported a table and tried to import it back into the table and i get an error:Invalid field count in CSV input on line 1. I used the output data to recreate the data i want to impoirt into my DB and i get the same error. I exportred the csv wth the field names included and excluded and both times get the same error stated above. thanx Steve