SQL Server Performance Forum – Threads Archive

export .xls file

I am exporting data from .xls file into a table in sql server 2000 using DTS. The first column is set to text in excel but the dts doe snot recognise it. It thinks it is integer and that is why it only exports the numbers and not the fileds with text in them??
Thanks

---

This may help… http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=5411 Raulie
hp

---

select transform button and at the column mapping select the column type as varchar

---

]]>