Hi,

I'm in the process of transitioning an excel/access (2003) based
solution to a web-based one. Right now, we have a dozen or so separate
spreadsheets and a couple of access databases that get updated several
times a day. I've managed to import most of the data into a mysql db
which I've tried to normalize as much as possible. This will be the
backend db for the webapp.

I've set up an ODBC connection from excel to the db and it works like a
charm; a few query tweaks and I can reproduce the data from all the
separate spreadsheets. But now, how about going the other way? I.e.,
can you set up an ODBC connection to *change* the data in a database?
I doesn't appear so based on what I'm seeing in excel. Changing data
in the spreadsheet does not show up when I click refresh on the
external data toolbar.

Is this a feature, or is there a way to override this behavior? I'd
really like to have db read/write functionality via odbc so the users
who are used to the excel interface can keep using it. It'd be neat to
have that kind of transparency, where everyone is working with the same
data whether its via a thick or a thin client.

Any tips would be appreciated!

Thanks