Home Forums SQL Server 2005 SQL Server Newbies SSIS not importing zipcode data correctly into SQL from Excel RE: SSIS not importing zipcode data correctly into SQL from Excel

  • Manually edit your excel connection string and add "IMEX=1", it tells the driver to always read "intermixed" (numbers, dates, strings etc) data columns as text. Note that this option might affect excel sheet write access negative.

    Check it out