problem importing CSV file to SQL 2k

[si_the_geek]

I would personally load the file in Excel and write a quick macro to add quotes to all cells, before re-saving as CSV and doing the import with delimiters... untested macro example:

Dim CurrCell as Range
  For Each CurrCell In ThisWorkBook.WorkSheets("[u]Sheet1[/u]").UsedRange
    CurrCell.Text = """" & CurrCell.Text & """"
  Next CurrCell