I am using Excel 2010 and database is Oracle 11g. I have an query which has output of 72,00,000 (72 Lakhs) records and it to be populated in excel.

I wrote the Excel VBA code to retrieve the data and populate in Excel.

I am getting the error "Problem Obtaining Data".

Please help me on this!!!!!