I was given a CSV file that I need to import into a SQL2K DB.

The table is already created in the DB with the correct structure.

The problem is the text fields in the CSV aren't closed in quotes or anything, so when I import the data, any textfield that has a cr/lf in it, screws up the import, because it thinks its the next record.

Anyone have any ideas how I might be able to get this imported without a bunch of manual legwork?