Categories
MySQL

ODBC MySQL Data connection in Excel

After swatting up on connecting QlikView to a MySQL database, I used the knowledge gained to create a similar set-up, this time with Microsoft Excel. This is how to dynamically connect to and query a MySQL database table directly from MS Excel on a local development machine. I did this using Microsoft Office Professional 2013. Download […]

Categories
QlikView

QlikView ODBC Connection

I am in the process of learning about QlikView, an awesome data visualisation application. It has the ability to connect to diverse data sources: anything from a CSV file to a database table. This is how to connect QlikView to a MySQL database using a ODBC on a local dev machine. An ODBC connector works […]