- I have a 16MB CSV file with 50,000 lines that I want to import into my database.
- I go to the PHPMyAdmin-Interface, choose IMPORT and set the correct options.
- The import fails with the error
Invalid field count in CSV input on line 24,333
. - When I look into the CSV file via Notepad++ and turn on the Option
View -> Show Symbols -> Show all Characters
everything in this line looks absolutely okay, means like exactly the same as in the lines before that were imported correctly.
How can I find the problem that the import is complaining about?
I cannot provide a sample of the data because it contains sensitive information.