I have had something like this before - but the data came from an Excel created csv - so might not apply to your scenario but might be worth a look.
Check the line before the one giving the error for any odd characters double or single quotes where you don't expect them to be.
In instances where I have seen this it was due to a comma in a text field which caused the field to be double quoted on its export from Excel. This in turn caused the problem in bulk insert.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx