Toad Tips and Tricks are a collection of suggestions, insights and how-tos from our in-house experts as well as Toad users from around the world. Do you have a tip you'd like to share? Submit your tip.
It has been my experience that when saving a datagrid as an Excel file, once you get above a 1,000 or so rows, the conversion takes expotentially longer to complete. I have found that when saving large datagrids, it is far more efficient to Save As a Delimited Text file, which will auto-open in Excel in a far shorter time. It is easy from there to save the file as an Excel workbook.
