Linking excel to WooCommerce database

[Andy B]

Hi, is it possible to link power query to a WooCommerce (MySql) database?

I need to get order data into excel in the fastest simplest way.

Many Thanks

 

[VBA Geek]

Hi, is it possible to link power query to a WooCommerce (MySql) database?

Power Query can be used to extract data from MySQL.

You will need MySQl connector Installed: https://dev.mysql.com/downloads/connector/net/

 

[Andy B]

Thank you for that. I'll give it a try.

I assume it will allow a connection to the host server for the database.