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);"