Connect My Excel Workbook to An Online MySQL Database

I have searched extensively for how to connect my Excel workbook to an online MySQL database such that information filled in on the Excel sheet will be automatically updated on the online database. Still can’t seem to find any solutions for that… Anyone kindly help out?

I have used this PHP XLS reader before.
It gets the data from an xls file via php, so then you can do as you like with it, like insert to an sql database.
To do updates, maybe set up a script as a cron job.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.