Problem in uploading excel data to SQL Server using SSIS

  • good catch!! SSCarpal:doze:

  • 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

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

  • 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