0 Replies Latest reply on Dec 17, 2007 10:37 AM by akuo

    Problems importing text from EXCEL

    akuo
      Help please!

      I'm using CF to import data from an EXCEL sheet that has a mix of numbers and text onto a SQL Server database. I get a successful import of numbers, but have problems with the text import. Specifically, quotes, apostrophes, dashes, etc are converted to null (?) values--when you output onto a webpage, they turn into "square boxes". Anyone run into this problem and knows a fix?

      FYI. I can't set up DTS (as some have recommended) since database server is housed outside my domain.

      Also, I would like to keep the format of the text if possible (ex. breaks, bold, italics, etc.)

      Thanks in advance!