Post reply

Null Values shows while importing from excel to Sql

  • November 7, 2012 at 10:54 pm

    #265178

    Hi,

    I have Excel File with following coloumn and sample data.

    example,

    No TranRefNo

    1 1111

    2 2222

    3 3333

    4 4444

    5 5555

    6 6666

    7 7777

    8 8888

    9 alstsh1234

    10 absgya1234

    The DataType of TranRefNo is General in Excel

    Problem 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!

  • November 7, 2012 at 11:00 pm

    #1556999

    avdhut.k (11/7/2012)

    Hi,

    I have Excel File with following coloumn and sample data.

    example,

    No TranRefNo

    1 1111

    2 2222

    3 3333

    4 4444

    5 5555

    6 6666

    7 7777

    8 8888

    9 alstsh1234

    10 absgya1234

    The DataType of TranRefNo is General in Excel

    Problem 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!

    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.

  • November 7, 2012 at 11:22 pm

    #1557002

    Thanks!

  • November 7, 2012 at 11:56 pm

    #1557010

    No problem, hope it all worked

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply