Here is the error I keep getting when I try to Import CSV data file into the Godaddy MSSQLAdmin web system. It would not insert all data from the CSV file into all the table columns. I just could not figure it out. I am a first time user of the Godaddy MSSQLAdmin database System. Please help!
Table : [hpc2005].[tbl_HeritagePres]
Columns : [pgID], [siteName], [linkLabel], [linkOrder], [pgName], [pgCaption], [pgType], [pgLocation], [pgURL], [pgAssoc], [pgHeader], [pgContent], [appLink], [appCode], [navHeader], [dateUpdated]
CSV file : HeritagePres8.csv
Import Report : Import processed in 3.23 seconds
18 rows have been inserted into [hpc2005].[tbl_HeritagePres]
217 lines have been ignored
Line 2 : wrong number of columns (line has been ignored)
Line 3 : wrong number of columns (line has been ignored)
Line 4 : wrong number of columns (line has been ignored)
Line 5 : wrong number of columns (line has been ignored)
Line 6 : wrong number of columns (line has been ignored)
Line 7 : wrong number of columns (line has been ignored)
Line 8 : wrong number of columns (line has been ignored)
Line 9 : wrong number of columns (line has been ignored)
Line 10 : wrong number of columns (line has been ignored)
Line 11 : wrong number of columns (line has been ignored)
Line 12 : wrong number of columns (line has been ignored)
Line 13 : wrong number of columns (line has been ignored)
Line 15 : wrong number of columns (line has been ignored)
Line 16 : wrong number of columns (line has been ignored)
Line 17 : wrong number of columns (line has been ignored)
Line 18 : wrong number of columns (line has been ignored)
Line 19 : wrong number of columns (line has been ignored)
Line 20 : wrong number of columns (line has been ignored)
Line 21 : wrong number of columns (line has been ignored)
Line 22 : wrong number of columns (line has been ignored)