ODBC Query Export to Excel - Message was too large to process

Help
, , , ,
1

Hi all,

I’m running a sql query through an ODBC connection and trying to export it to Excel. The query is running to completion, report is being exported fully. However, this error populates after the export when trying to run this process in debug mode.

image

Studio 2019.10.1
Using an Azure VM

Searching has returned no solution, although many users have reported this issue. Any ideas?

Thanks!