Hello,
Does anyone knows how to export mySQL database into my excel using VBA? Or is it even possible? Thank you
Regards
Abel
Hello,
Does anyone knows how to export mySQL database into my excel using VBA? Or is it even possible? Thank you
Regards
Abel
You can use ADO in VBA to push/pull data from pretty much any db as long as you have the requisite ODBC Drivers installed on your machine such that you can connect to the server.
Do a google on ADO VBA etc and you should find a few examples -- also search the forum ... I'm relatively new here but I would assume there are some examples around here that will tie in closely to your requirements.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks