Good afternoon. I am trying to import a csv file to a SQL database hosted through GoDaddy. However, I continue to receive an error which states "Line 7 has 24 values (20 expected)". Line 7 in my .csv file only has 20 columns (20 values) and no matter what I try I cannot get my data to import. I have tried removing line 7 from my .csv file altogether, but then the error says a different line has 24 values and only 20 are expected. I have tried removing countless lines of records to see if I can get rid of this error message to no avail. Obviously, there is a deeper problem here. Does anyone have any suggestions as to what my problem(s) might be? I am not extremely familiar with Databases. While I did take a course or two in college in database development we worked with Oracle and the DB was hosted on the school servers. Thus, I am not very familiar at all in my current DB environment. Any help, suggestions, or ideas would be greatly appreciated. Thanks in advance.
jobojo
0
Light Poster
Recommended Answers
Jump to PostMake sure that line 7 (and all lines for that matter) in your csv don't have more than 19 commas. That will give you 20 values in a csv file. This line in a csv file:
1,,2,,3
actually has 5 values, it's just that 2 of the values …
All 5 Replies
darkagn
315
Veteran Poster
Featured Poster
jobojo
0
Light Poster
princekool
-3
Light Poster
jpsingh1906
0
Newbie Poster
iamthwee
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.