Update a table in DB2 from Access
Posted on 2006-10-23
I am trying to develope code to update a table in a DB2 database.
Dim sqlStr As String
not linked-----------v verify SQL
sqlStr = "Update TableInDB2 D Inner Join TableInAccess A On D.AcctNo = A.AcctNo Set D.Budget = A.Budget"
strDBConnect = "Connection:=ODBC;DSN=PDB2;UID=uuuuu;pwd=ppppp;DBALIAS=PDB2"
Set cmd = New ADODB.Command
cmd.CommandText = sqlStr
cmd.ActiveConnection = strDBConnect
Set rst = cmd.Execute
Please put above code in a shape and list your assumptions.