Microsoft Access link to Hikashop.

Hi all, first time posting

I've been working for the past week on getting all my data from Hikashop into Microsoft Access, and I was curious to see if anyone had attempted that before?
I am using MS Access + MyODBC 3.51 connected via SSH to MySQL remote database.

I use Hikashop for a school selling various dance class and clothing, so there's a lot of custom field and product variant, so far it's working quite nicely.
At the moment I got all the different table linked up together giving me all the information I need in a nice view with the ability to export to MS Excel, and
also edit the information.

Love hikashop good work guys. Quite happy since I got it.

Hi,

Thank you for your message.
Do not hesitate to post the script you're using. It might be useful to other users wanting to do the same in Access.