How to export more than 3,00,000 records into a single Excel Work Sheet?

  • Hi,

    I have a query which returns more than 3,00,000 records. Is there a way to get this big an amount of data into a single Excel Worksheet??.....Please tell me how to.

    Looking forward to your replies.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

  • deleted....misread number pf rows

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • Nevermind, I was thinking too much. It was simple, you just have to export the data to a .csv file using DTS and then edit the data for dates and then save it in Excel format.

    Hope it helps others like me. 🙂

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

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

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