We have an Excel spreadsheet we are converting to a SQL table using DTS.
One column of the Excel spreadsheet has both Text and Numbers, however in
the SQL table we want the numbers to be converted to text. The DTS package
defaults this column to nvarchar data type, which is OK for the text, but
the numbers are coming out as <Null>. Does anyone know how to convert such
a column to all text values?
We would prefer not to change the cell format in the Excel spreadsheet.