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
1rohan2289
Newbie
Points: 3
More actions
June 5, 2013 at 8:00 am
#1621356
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