I have a DTS package that drop/create/import an excel file into SQL.
The data in Excel looks like this: (They are in the same column)
Some of the data are string, some are numeric, but I want to treat them as string, so in creating table step in DTS,
I create the field using nvarchar(255), but for some reason, only those numerix values got inserted, not the string
type. I changed the type in excel itself to text (so the data align to the left), but the string data is still missing.