Post reply

SQL server table to txt file

  • December 31, 2010 at 8:25 am

    #388531

    Hi,

    I have a sql server database in which a table has 24 million rows.

    I want to take all the rows out to a excel file. I did that but only 1 lakh rows could accomodate in it,

    so I am thinking of putting the output in a txt file?

    How can I do it? or is it possible to increase no of rows in a excel file?

    Any other way?

    HAPPY NEW YEAR.

    Regards,

    Sushant

    DBA

    West Indies.

    Regards
    Sushant Kumar
    MCTS,MCP

  • December 31, 2010 at 8:41 am

    #1268124

    Why Excel???

    You won't be able to open it anyway...

    Use BCP (see BooksOnLine for details) or SSIS and store the data in a txt or csv format.


    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]

  • December 31, 2010 at 12:22 pm

    #1268169

    Thanks a lot.

    Regards,

    Sushant

    DBA

    West Indies

    Regards
    Sushant Kumar
    MCTS,MCP

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

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