What is the best way to export data from mySQL database in to excel.



Currently, I have a datasubset in an interface that is used with the function plug-in "getdatasubsetdownloadlinkfromprocess" 

As it works now, the users selects from a dropdown, the data he or she wants to see, the data is populated in a grid and there is a link to click "Click here to export this data to Excel"


This works fine with a small amount of data (up to 1000 rows) but when it gets to 3,000 rows of data, it fails.


I have read on some posts here that "getdatasubsetdownloadlinkfromprocess" doesnt work well with large sets of data


My question is, what is the best way to export data from a mySQL database to excel. I see a SQL to Excel smart service but I am having trouble setting that up.


Any help or advice would be greatly appreciated.



  Discussion posts and replies are publicly visible