MySql CSV import from MSSQL

Question

I've got a CSV file exported by MSSQL. When I try to import it into MySql, PhpMyAdmin returns "Invalid column count on line 2316". I don't know why. Can you help me? heres the code around line 2316:

2312: 708;Nein;0;;Ja;Nein;0;Ja;;Ja;;Ja;;Ja;;8;;5;;;;Ja;Nein;Nein;Ja;Nein;Nein;Nein;Ja;Nein;Ja;Nein;Nein;Nein;Nein;Ja;Nein;Ja;Nein;Nein;Nein;Nein;Nein;Nein;Nein;Nein;Nein;Ja;Nein;Nein;Nein;Nein;Ja;Nein;Nein;Nein;Ja;1;Nein;;Nein;;Nein;;Ja;1;Nein;;Nein;;;5;Nein;;;Hildebrecht, Susanne;;040-65432154;[email protected];;;1
2313: ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
2314: ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
2315: ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
2316: ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

Charset of the File is UTF-8 and the Database has utf8_general_ci. MySql Version is 5.1.43-nmm4-log.

Thank you in advance!

Ashwin A · Accepted Answer · 2011-09-06 11:58:40Z

1

Refer: http://andrewodendaal.com/phpmyadmin-invalid-field-count-in-csv-input-on-line-1/ OR Quick fix for this problem is to change the delimiter symbol manually. Use semicolon ( ; ) as field delimiter instead of comma ( , ).

answered Sep 6, 2011 at 11:58

Ashwin A

3,83425 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

andred Over a year ago

I tried it this way, but my MySql user does not have the rights to use LOAD DATA..

Ashwin A Over a year ago

grant file on . to user@hostname identified by 'password'; Refer: dev.mysql.com/doc/refman/5.1/en/…

andred Over a year ago

I solved it by using the command-line at another server using the mysql --infile opperator (or something similar). I don't have the code I handled it with here, right now. Sorry!

Collectives™ on Stack Overflow

MySql CSV import from MSSQL

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related