Post reply

Problem in uploading excel data to SQL Server using SSIS

  • May 17, 2011 at 12:56 am

    #1325622

    good catch!! SSCarpal:doze:

  • May 19, 2011 at 8:05 pm

    #1327452

    What is the format of an Excel query that uses FORMAT?

    Here are some rows from an Excel file that have the scientific notation problem. It is an .xls file.

    NCPDP1

    3356260

    3329706

    3350612

    3350612

    03350612

    3337397

    3313210

    3340685

    3332385

  • May 19, 2011 at 8:15 pm

    #1327453

    I tried saving the Excel file as 2007 format and the scientific notation bug went away.

  • May 20, 2011 at 12:40 am

    #1327488

    hey hi sunder can you just provide me demo excel sheet which contain these data i can look into that and i will solve this but i need excel sheet atlest some part of it

    You can visit my blog and send me query i willl provide personal Email ID

    http://bimentalist.wordpress.com

Viewing 4 posts - 31 through 33 (of 33 total)

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