VBA excel, MySQL DB

M

murugavelmsc

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
minutes. But I have present the data in excel take 30 minutes. How t
avoid this.

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


Thanks,
Murugavel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Return column values based on criteria (HLOOKUP & VLOOKUP?) 0
Connecting Excel 2007 to MySQL db? 0
ODBC connection from Excel 2008 on Mac OS X 0
Update MySQL database using Excel VBA 1
VBA - exporting serial letters to single documents 0
Dates In Excel 5
Access for MySQL data reports only 5

Top