UPDATE T
SET T.Col1 = A.Col1, T.Col2 = A.col2
FROM Table1 T INNER JOIN Table2 A ON T.ID = A.ID

Dim SQL as String

SQL = "UPDATE T " & _
	"SET T.ClrComm = A.f15 " & _
	"FROM opershare T inner join [E61.txt] in 'D:' [Text;HDR=NO] as A " & _
	" ON T.tradeNo = A.f2"

CurrentProject.Connection.Execute SQL

UPDATE T 
SET T.ClrComm = A.f15 
FROM opershare T inner join [E61.txt] in 'D:' [Text;HDR=NO] as A 
ON T.tradeNo = A.f2;

UPDATE opershare inner join [E61.txt] in 'D:' [Text;HDR=NO] as A ON opershare.tradeNo = A.f2;
SET opershare.ClrComm = A.f15 

UPDATE opershare inner join [E61.txt] in 'D:' [Text;HDR=NO] as A 
	ON opershare.tradeNo = A.f2
SET opershare.ClrComm = A.f15 

UPDATE tblAddress
INNER JOIN tblZipCodes ON [tblAddress].[ZipCode] = [tblZipCodes].[ZipCode]
SET [tblAddress].[City]  = [tblZipCodes].[City], 
    [tblAddress].[State] = [tblZipCodes].[State]
WHERE ([Country] = 'US')

UPDATE opershare 
	inner join [E61.txt] As A in 'D:' [Text;HDR=NO] 
		ON opershare.tradeNo = A.f2
SET opershare.ClrComm = A.f15 

SELECT A.* from [E61.txt] As A in 'D:' [Text;HDR=NO]

UPDATE opershare inner join 
		(SELECT * from [E61.txt] in 'D:' [Text;HDR=NO]) as A
	ON opershare.[tradeNo] = A.[f2]
SET opershare.[ClrComm] = A.[f15] 

SQL = "UPDATE opershare Set opershare.ClrComm = (select TOP 1 A.f15 from [EQM06_20120614.csv] As A " & _
"in 'D:' [Text;HDR=NO] where a.f2=opershare.tradeNo);"