There is a fair bit to doing something like this. What you need to do is to
use the on change event in the spreadsheet to triggeer the update. Knowing
which line you have updated you can query the database to retrive an ADODB
recordset (connected). You must return just the one specific record in the
recordset, that corresponds to the row in the excel file that you have just
modified. You can now update that record and close the connection...

If you are still interested I have a function that returns a recordset based
on an SQL statement, which I can post for you ...

HTH

"AAA" wrote:

Hi,

I use excel to connect my database through the ODBC.
when the data pop up on Excel sheet, how could I make some data update in
this sheet which reflect into my database??


Thanks!

Danny