Direct Query Excel Export

[idem84]

Any suggestions to export a query directly to Excel with a lot of records (500,000) (without showing them first in grid) because I'm having performance problems (ram,time)
Similar to "results to file" in Microsoft Management Studio
Thanks in advance!

[alexa]

You can create a view based on the query the result of which you want to export, then right-click the view in Database Explorer, select 'Export Data...' and complete the wizard.