InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 02:35:41 GMT20http://www.sqlservercentral.com/Forums/Topic741762-148-1.aspxhi CozyRoc,I did what has been told in the discussion which you forwarded to me but that didn't solve my problem.I am using Microsoft Office Excel 2003 (11.5612.5606) , And i am using SSIS not DTS , Please help !!!!ThanksShobhitSat, 27 Jun 2009 00:14:03 GMThi.shobhit76http://www.sqlservercentral.com/Forums/Topic741762-148-1.aspx[quote][b]hi.shobhit76 (6/25/2009)[/b][hr]Hi,When i load my excel sheet onto a connection manager in an excel source and preview the data present in my excel sheet then i get integer values shown as NULL in the preview. The column is an alphanumeric column which has data in the form of text. But on some of the column cells the value is an integer which should be read as varchar() but instead the preview of the sheet shows me NULL for those records. I have already tried changing the format of the excel sheet cells as general and other combination but it didn't work. This is also true vice` versa e.g when the data is numeric in initial cells then alphanumeric values is shown NULL.Is there any solution to this problem ? Please help it is creating a lot of problems for me. Also provide alternative solutions if this cannot be worked out.Thanks for the help.Shobhit Bansal[/quote]This is well known issue with the Jet Excel driver. Check this [b][url=http://www.sqlservercentral.com/Forums/Topic412102-265-1.aspx#bm585916]discussion[/url][/b] for possible resolutions.Thu, 25 Jun 2009 07:56:03 GMTCozyRochttp://www.sqlservercentral.com/Forums/Topic741762-148-1.aspxHi,When i load my excel sheet onto a connection manager in an excel source and preview the data present in my excel sheet then i get integer values shown as NULL in the preview. The column is an alphanumeric column which has data in the form of text. But on some of the column cells the value is an integer which should be read as varchar() but instead the preview of the sheet shows me NULL for those records. I have already tried changing the format of the excel sheet cells as general and other combination but it didn't work. This is also true vice` versa e.g when the data is numeric in initial cells then alphanumeric values is shown NULL.Is there any solution to this problem ? Please help it is creating a lot of problems for me. Also provide alternative solutions if this cannot be worked out.Thanks for the help.Shobhit BansalThu, 25 Jun 2009 06:48:15 GMThi.shobhit76