Help for modify data in excel!
 

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

Help for modify data in excel!
 

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

Help for modify data in excel!
 

Jim Thomlinson wrote:
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.

--

Help for modify data in excel!
 

YEs, PLease post it!

Thank you so much!



"Jim Thomlinson" ¦b¶l¥ó
¤¤¼¶¼g...
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