PDA

View Full Version : Returning External Data from MySQL Server



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:

RichardSchollar
01-29-2007, 02:35 AM
Hi

See XL-Dennis' article here:

http://excelkb.com/article.aspx?id=10179&cNode=3F6N6J

Best regards

Richard

Bob Phillips
01-29-2007, 02:50 AM
See here (http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForMySQL)