1

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.

5
Contributors
5
Replies
9
Views
7 Years
Discussion Span
Last Post by iamthwee
1

Make 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 are null/blank.

0

Make 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 are null/blank.

Darkagn, thank you for the information. That was my problem exactly, In my spreadsheet, I had several commas throughout which created the error. I was able to remove all of the 'extra' and unnecessary commas and now I was able to get half of my records to upload. I am receiving another error message for the other half of the records, but hopefully I can figure that out tomorrow. Thanks again, your help was greatly appreciated, solved my issue, and save me some additional headaches.

0

i am importing csv file in sql db table using c# code, csv file split with semicolon(;).
when data is import in table then all data is fill in only first two columns and other columns show null. how can solve this problem...**.help me **

0

Your csv file isn't a csv file, it's separated with semicolons.

Maybe do a quick search and replace and swap all the semicolons for commas, but you have to be very very careful with this approach.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.