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

[techgnome]

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

Is that necessary? I mean, isn't there an option when saving as CSV to add text quote identifiers? It's been a while since I've had to make a csv through Excel, but I thought I remembered something to that effect in there.

-tg

[si_the_geek]

Is that necessary? I mean, isn't there an option when saving as CSV to add text quote identifiers? It's been a while since I've had to make a csv through Excel, but I thought I remembered something to that effect in there.

I did a quick test and didn't get any options (even in the Save As dialog), but it probably is an option somewhere!