Connect To MySQL and Retrieve Data

[OceanBlue]

I would like to be to Connect To MySQL and Retrieve Data

Never done it, and not too sure how, or where I can find the steps or Tutorial for it?

[DonkeyOte]

First, you will need to ensure you have installed the MySQL ODBC Driver to your client machine.

Thereafter you can connect to your MySQL DB a number of ways... VBA using ADO for ex. or via External Data Queries (eg Externally Sourced Pivots)

[OceanBlue]

Do you have a Step by Step guide for :
VBA using ADO for excel?
Never done this before.

First, you will need to ensure you have installed the MySQL ODBC Driver to your client machine.

Thereafter you can connect to your MySQL DB a number of ways... VBA using ADO for ex. or via External Data Queries (eg Externally Sourced Pivots)