jimoo
01-28-2007, 09:17 PM
I have an external MySQL server that I can connect into fine from my local pc. I can use the MySQL Query Browser, etc. to return data.
Assume I have a table called Books - I want to return all rows with a booktype of "FIC"
What is the VBA connection / Query String I will need to ensure I am connected and return the data to the spreadsheet. I anticipate automationg it to menu item or button later.
Thanks
:beerchug:
Assume I have a table called Books - I want to return all rows with a booktype of "FIC"
What is the VBA connection / Query String I will need to ensure I am connected and return the data to the spreadsheet. I anticipate automationg it to menu item or button later.
Thanks
:beerchug: