Returning External Data from MySQL Server

[jimoo]

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

[RichardSchollar]

Hi

See XL-Dennis' article here:

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

Best regards

Richard

[Bob Phillips]

See here