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.
All 5 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.