Help for modify data in excel!

[AAA]

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

 

[Guest]

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

 

[Jamie Collins]

use the on change event in the spreadsheet to
triggeer the update. Knowing which line you have
updated you can query the database

Can you post the code for this part of the process, please.
Jamie.

--

 

[AAA]

YEs, PLease post it!

Thank you so much!

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