I am trying to import an Excel 2000 spreadsheet of data into a SQL 2000 table
though DTS and continue to get the error below.

Error at Destination for Row number 1. Errors encountered so far in this
task:1.
Line 1: Incorrect syntax near 'COLLATE'.

What can be done to remove this problem?