best way of storing data from db in excel RRS feed

  • Question

  • User421672444 posted


    i am getting lakhs of record from sql db and i want to store in excel which will be used be user. i know ways to get and insert data into excel. but i want to consider performance , since the records are huge. so what is the best way to retrieve and store huge data in excel .



    Monday, April 9, 2012 11:04 AM


  • User-851967432 posted

    Well my first suggestion would be considering filtering the data down into smaller resultsets if possible.

    Secondly and realistically, large resultsets are large resultsets and take time to move regardless of the methodology or technology. With that idea in the forefront, it is reasonable for the user to request such large amounts of data in a spreadsheet format? Not usually.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, April 9, 2012 11:10 AM