Post reply

Import from Excel (insert into ---- select from Openrowset : not in the same order as in Excel Why? How to avoid this

  • March 22, 2011 at 2:01 am

    #237137

    Hello,

    I have to import data from Excel from TSql stored proc.

    The import is going well but the order of rows are not the same as in Excel .

    This is mandatory for the process...

    1. How to avoid this ?

    2. if not possible, how to retrieve rownumber from the Excel sheet and insert it in the table?

    Many tks.

  • March 22, 2011 at 2:28 am

    #1301712

    you have an alternate of linked server to excel.

    Follow this on how to create LS for excel.

    http://support.microsoft.com/kb/306397

    ----------
    Ashish

  • March 22, 2011 at 3:11 am

    #1301737

    Tks for this.

    However problem with linked server is that I do not know how many files I have to import... This depends from day to day.... As far as I have understood Linked server you have to mention the name if the file.... (which is unknown also) ....

  • March 22, 2011 at 3:35 am

    #1301748

    yes correct but if that is not so frequent activity then you can rename old file which you already inserted and then new file should be named exactly as we configure in linked server and must be in same location.

    ----------
    Ashish

  • March 22, 2011 at 4:18 am

    #1301767

    hum .... it's a daily activity ...

    However, I have found a way to create linkedserver with sp so I'm currently trying to test this in a loop....

    Hope this will solve my problem.

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

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