again update problem

A

Art Vandaley

Hi,

I want to update data of an external table. I need to write VBA code with
UPDATE Statement but I don't know using IN Clause together with UPDATE. Can
you please write down a sample code in order to have an idea about correct
syntax. Best Regards.
 
A

Alex Ivanov

UPDATE Table1 SET Data1 =1, Data2 ='Data 2'
WHERE RecID In (select recid from query2)
 
V

Van T. Dinh

UPDATE tblTest IN "D:\AccessTests\A2K2_MyTest\Test02.mdb"
SET Pole1 = 10
WHERE Pole1 = 1


tblTest is in the "external" JET database Test02.mdb.
 
Top