MSSQL 2000 - import data error

Can someone give a relative newcomer some advice please?

I have a comma delimted file that I wish to import into a table in MSSQL 2000. I am using the import wizard and completing all necessary tabs but when I run the import, I get an error that the file failed to import. Clicking the message reveals "Error at Destination for Row 1523. Errors encountered so far in this task: 1."

There are 1523 data rows in my CSV file plus a header row. The wizard accepts that I have a header row and displays the text accordingly. I have tried deleting the last record in the file but the same error is displayed - except that the row number changes to 1522. I'm assuming that there's a problem with the format of the data but can't see what it is.

Does anyone have any advice?

Thanks in advance!