When trying to write range a datatable with 117 columns and 53K or 26K rows downloaded from ODBC database through SQL query, Unexpected process Termination error is occurring. Please advise any solution or workaround to paste the data table into excel.
Execute query will give you output as datatable and then to write to excel you can use excel application scope-> write range and give sheet name and datatable and range(if needed )
The issue is being faced in write range activity.
Add the screenshot of write range this will hjelp us understand more about what is missing
If i download the query manually through MS access,the output has 26K rows and 117 Columns.
Other Queries with less rows and columns are executing and pasting properly.
But the query with huge data is unable to paste into excel
use inside Excel application scope and then do write range,
let us know if this helps
The above steps shown in screenshot is kept inside Excel Application Scope.