Dears,
I was so confused when reading documents about updating record in th
recordset using ADO. So please help me.
How can I change a record in the recordset and update it to the sourc
data.
Thanks so much for your help.
OverA

--
OverA
-----------------------------------------------------------------------
OverAC's Profile: http://www.excelforum.com/member.php...fo&userid=3239
View this thread: http://www.excelforum.com/showthread.php?threadid=52952

If your recordset object is RS:
To update/change a value in the recordset:

RS.Fields("MYFIELD").VALUE = your Value ' ensure value is the same as the
underlying type

To update the source:

RS.Update

For this to work, 1. you need to have opened the recordset with the
'correct' cursor 2. the data source must support Update (or UpdataBatch);
some data sources (like Excel) do not support this functionality.

"OverAC" wrote:


Dears,
I was so confused when reading documents about updating record in the
recordset using ADO. So please help me.
How can I change a record in the recordset and update it to the source
data.
Thanks so much for your help.
OverAC


--
OverAC
------------------------------------------------------------------------
OverAC's Profile: http://www.excelforum.com/member.php...o&userid=32396
View this thread: http://www.excelforum.com/showthread...hreadid=529527

AA2e72E Wrote:
2. the data source must support Update (or UpdataBatch);
some data sources (like Excel) do not support this functionality
Ôi.
My data source is an another Excel file, please help......

OverAC


--
OverAC
------------------------------------------------------------------------
OverAC's Profile: http://www.excelforum.com/member.php...o&userid=32396
View this thread: http://www.excelforum.com/showthread...hreadid=529527