Toad World® Forums

Copy all rows in grid and paste it into excel

In Toad for Data Analyst when you click on the grid to highlight everything. Then right click and select copy rows. It only copies 500 rows and does not copy the rest.

How can you get it to copy everything?

I could not reproduce this. How are you selecting all rows? I go to the very left corner of the grid and click. This selects all rows.

Also, do you have all rows retrieved? Or are you paused at 500 rows? It will only select the number of rows currently fetched. Try right clicking and Reading all rows then select and copy.