extract data to excel from CC debugger

[former_member947143]

in GRC 5.3 SP10, I executed an SQL query in CC debugger to get a table data. The data is shown in the web page in tabular format. But I need the data to be imported to excel file. When I right click on the table data in web page and select "export to Microsoft excel" option..it opens a new excel but can not extract data from external data source and shows message that - it can not return data from query. ..

Can you please tell me how can I import data from sql query output of CC debugger.

[Former Member]

Hi,

I dont see the export to excel option, but I m successful with copy and paste onto excel. Highlight all rows and copy, and then paste in excel. Make sure to see all rows in one page by increasing rows per page(click enter to refresh page).

Thanks

Laks

[former_member947143]

If number of rows are less in the table then copy paste is fine.

But if table contains very large amount of data e.g. 30000 rows, then what could be the easy way?