Export Query Results as Excel

[GriR]

Hi,

When I run a long-lasting query and after that try to save results as Excel - it seems that query is run once again and I have to wait same long time ...
What I'm doing wrong?

Regards,

G.R.

 

[mike]

Don't "export the query".

If you right click on the results grid somewhere and choose "Copy to Excel", it will just put what is in the results grid to Excel.

Make sure that you have all of the data in the results grid though. There is a SQL Window preference that can limit the number of rows returned. If that is set, you need to make sure to press the double green arrows that is underlined to "Fetch Last Page".

 

[GriR]

Thanks! That's the trick! But why this button exists?

 

[Hilarion]

As far, as I know, this is a feature you can use to export query result to MS Excel without loading the results first to the grid. In case of a query that returns first rows fast, but has a lot of data, you can execute the query to the grid, to take a look at the first rows, and then use the export to Excel button, to have the whole query exported, without having to load it whole to the grid.

I've never uses that feature myself, so I'm just guessing, but I've seen threads on this forum, mentioning those scenarios.