Post reply

Unable to import more than 65523 rows from excelsheet to sql table using OPENROWSET

  • May 17, 2011 at 3:10 pm

    #239758

    SORs$A13:M

    select * from [SORs$A13:M]

    I want to import more than 100,000 rows but openrowset stops at 65523 rows when I try to import data from excel by specifying the row numbers

    A13 TO M - as I want it to go till the end.

    I am trying to do this using SSIS.

    Please let me know any suggestions.

  • May 17, 2011 at 3:18 pm

    #1326148

    Duplicate post. No replies please.

    Original post: http://www.sqlservercentral.com/Forums/FindPost1110610.aspx


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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