DTS from Excel to SQL server
I had a problem when i was trying to use SQL server DTS to import data from an Excel to the SQL database. One of the columns in the spreadsheet contained 2 different types of values ex 100 & 200-1 and the column is formated as General.
When i try to do an import, DTS imported only the values that did not had a dash (-) and inserted the other as null. When i changed the column formatting to a text it did the opposite – weired!
Turns out DTS expectes the datatype in a column to be uniform to do the full import. I can get around this in 2 ways – do an import twice or add aâ€? ‘ â€? as the first character and run the DTS, it imports ok.
ideas! 
No trackbacks yet.