Forum Replies Created

Viewing 1 replies (of 1 total)
  • 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)

Viewing 1 replies (of 1 total)