ExcelBanter - VBA excel, MySQL DB

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - VBA excel, MySQL DB (https://www.excelbanter.com/excel-discussion-misc-queries/447154-vba-excel-mysql-db.html)

murugavelmsc

VBA excel, MySQL DB

Hi,

I have written a coding to generate the report from MYsql DB.

But I have retrieved the data from the MYsql database is less than a minutes. But I have present the data in excel take 30 minutes. How to avoid this.

I need to present the data in single shot not the row by row.
Is it possible how?

Thanks,
Murugavel S

All times are GMT +1. The time now is 09:45 PM.