sqlbulkcopy excel and sql columns not matching RRS feed

  • Question

  • My error
    The given ColumnMapping does not match up with any column in the source or destination.

    I'm using sqlbulkcopy to move data from excel to sql.
    I'm not famaliar with the sql field type. I've trying setting everything to text and number, but still get this error.

    How can I assure that the columns match in excel and sql serverr.
    Monday, September 24, 2007 10:40 PM