SQL Server Performance Forum – Threads Archive

Excel file import error

I’m trying to import an Excel file to SQL server 2000 using DTS. One of the columns is a text column and contains mainly text, however a few rows in this column contain just numbers. When I import the file the rows in that column containing numbers appear as NULL, whereas the text rows are ok. I’ve seen other posts about the first 7 rows determining format and formatting the file etc and I’ve tried that but it didn’t work. The first 10 or more rows are full of text, and surely numbers should be easily converted to text by SQL and not ignored? The way that I’ve got round this is by adding a space to the start of the number (making it text) and it worked, but this is not ideal. Thanks for any help.

---

I once had the same issue. http://support.microsoft.com/default.aspx?scid=kb;EN-US;236605
http://support.microsoft.com/default.aspx?scid=kb;EN-US;194124
http://support.microsoft.com/default.aspx?scid=kb;DE;319951

---

]]>