Devart Forums

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!

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.