InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 17:54:44 GMT20http://www.sqlservercentral.com/Forums/Topic1382261-391-1.aspxNo problem, hope it all workedWed, 07 Nov 2012 23:56:00 GMTTavahttp://www.sqlservercentral.com/Forums/Topic1382261-391-1.aspxThanks!Wed, 07 Nov 2012 23:22:31 GMTavdhut.khttp://www.sqlservercentral.com/Forums/Topic1382261-391-1.aspx[quote][b]avdhut.k (11/7/2012)[/b][hr]Hi,I have Excel File with following coloumn and sample data.example,No TranRefNo 1 11112 22223 33334 44445 55556 66667 77778 88889 alstsh123410 absgya1234The DataType of TranRefNo is General in ExcelProblem is,When I import the Excel File in SQL values of TranRefNo till No 8 imports correctly,but, for 9 and 10 where TranRefNo is alphanumeric Values it shows as NULL Values.Please give me solution,i need this for urgent requirement.I had also tried in SSIS but same problems occurs.Is there other alternative in SSIS.Thanks in Advance![/quote]TransRefNo has to be TEXT category not GENERAL (use TEXT TO COLUMN for most accurate result) & database table will have to be VARCHAR(X) That should fix it.Wed, 07 Nov 2012 23:00:31 GMTTavahttp://www.sqlservercentral.com/Forums/Topic1382261-391-1.aspxHi,I have Excel File with following coloumn and sample data.example,No TranRefNo 1 11112 22223 33334 44445 55556 66667 77778 88889 alstsh123410 absgya1234The DataType of TranRefNo is General in ExcelProblem is,When I import the Excel File in SQL values of TranRefNo till No 8 imports correctly,but, for 9 and 10 where TranRefNo is alphanumeric Values it shows as NULL Values.Please give me solution,i need this for urgent requirement.I had also tried in SSIS but same problems occurs.Is there other alternative in SSIS.Thanks in Advance!Wed, 07 Nov 2012 22:54:29 GMTavdhut.k