nzrubin
asked on
Import CSV to SQL
Hello Experts
im trying to import CSV file into SQl database. i have a read through many articles here but it is not yet clear how to do it.
when i import through PHPMyAdmin (accordingly to ID: 22730029) i have an error
"Invalid field count in CSV input on line 1."
my test.xls file is attached
could you advice please?
Test.xls
im trying to import CSV file into SQl database. i have a read through many articles here but it is not yet clear how to do it.
when i import through PHPMyAdmin (accordingly to ID: 22730029) i have an error
"Invalid field count in CSV input on line 1."
my test.xls file is attached
could you advice please?
Test.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
the same error when i upload file to MySQL by PHPMyAdmin
Invalid field count in CSV input on line 1.
Invalid field count in CSV input on line 1.
then pleas upload the file as .txt, but with the csv-content
ASKER
here it is
DBFromBCM8Aug08-.txt
DBFromBCM8Aug08-.txt
ASKER
i tried CSV using LOAD DATA options when i import in mysqil and it works...
ASKER