Toad World® Forums

export all query records to Excel

Unless I force the view of the last record in a result set, the export to Excel just gives displayed rows (or first 1000). Is there a way to default to exporting all records (and then another option to just display selected records)?

There are two ways to do this.

  1. Use the Export Query Add Query option. This will execute the query newly and export all rows.
  2. Go to the Options and search for “Rows”. There are two options for “Number of Rows to fetch initially”. Change these both to unlimited. This was cause the Database Browser and F9 in the editor to retrieve all of the rows.