SQL Server Performance

export .xls file

Discussion in 'SQL Server DTS-Related Questions' started by fmardani, Jul 1, 2005.

  1. fmardani New Member

    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
  2. Raulie New Member

  3. dineshasanka Moderator

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

Share This Page