VBA excel, MySQL DB

Hi All,

I have develop a tool to extract the data from mysql db and present it in Excel.

In the Mysql DB, it have 50000 records in a table.

But it takes more time to represent the data into excel (nearly 30 minutes).

Is there any other solution?

Thanks in advance.

Murugavel S

Hi murugavelmsc

Do you have a GUI for your MySQL database? If so, it may offer a facility whereby you can execute your query and view the results in a table, whicjh can then be exported to Excel. We do this all the time using a product called SQLyog.