How can i update a mysql table using an offline excel sheet?

Question

I would like to update a mysql table, with data I input into an excel sheet.

Every time I save my excel sheet, a command could be triggered, that updates mysql.

Has anyone done anything like this before?

Am I right in thinking I would need to install a MySQL ODBC driver on my server, and write a vb macro as a go between?

Answer 1

Why does it have to be done like this? I mean, it probably can be done, but it seems an awful long and error-prone way round, especially as it is a one-way trip (from Excel to MySQL). In any sane application, you want to read the existing data out of the database into the user interface first, so the user can see what they are updating befroe they do the update.

The best way forward is to write a webform with associated PHP scripts, that does this:

1. Read the MySQL table

2. Display the current values on the webform

3. User enters updates

4. Webform passes the updates to PHP, which sanity checks them

5. Webform puts out error messages if necessary

6. PHP updates the table.

Answer 2

i think of what you're able to desire to do is create an odbc that connects on your excel spreadsheet report so that's taken care of basically like a database. carry out a query on it and keep the effect on your Mysql database

Answer 3

You should really use some other software for example LibreOffice. It probably will work smoother, easier and better.