Welcome to WebmasterWorld Guest from 50.19.190.144

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

importing with phpmyadmin

     
8:05 pm on Dec 19, 2006 (gmt 0)

New User

5+ Year Member

joined:Dec 19, 2006
posts:11
votes: 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

9:11 pm on Dec 19, 2006 (gmt 0)

Senior Member

WebmasterWorld Senior Member eelixduppy is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Nov 12, 2005
posts:5966
votes: 0


Not sure exactly what is causing your problem here. A search [google.com] may bring up more clues.

It could also be due to the version of mysql being used; not quited sure on this one, though.

..and Welcome to WebmasterWorld!

9:49 pm on Dec 19, 2006 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 29, 2003
posts:790
votes: 0


What does the first line of your file look like?
10:56 am on Dec 20, 2006 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Nov 26, 2003
posts:1133
votes: 0


Try to export any data with phpMyAdmin and then compare the both CSVs - you may spot the problem on your own

Merry Xmas and Welcome to WebmasterWorld!

Michal

12:36 pm on Dec 20, 2006 (gmt 0)

Senior Member from US 

WebmasterWorld Senior Member henry0 is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Apr 19, 2003
posts:4388
votes: 2


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.
5:56 pm on Dec 20, 2006 (gmt 0)

New User

5+ Year Member

joined:Dec 19, 2006
posts:11
votes: 0


Hi Henry0, what was the name of the program? I saw one but can't remeber the name.
Thanx
Steve
6:37 pm on Dec 20, 2006 (gmt 0)

New User

5+ Year Member

joined:Dec 19, 2006
posts:11
votes: 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
9:24 pm on Dec 20, 2006 (gmt 0)

Senior Member from US 

WebmasterWorld Senior Member henry0 is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Apr 19, 2003
posts:4388
votes: 2


Tiki,
Check you mail

I will not post a ccial link here

Henry

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members