This is how to write into SQL db table using excel VBA

[Mavyak]

[VBA]strConn.Open
strConn.Execute strSQL, lngRecsAff, adExecuteNoRecords[/VBA]

It looks like you're executing the "Execute" method of a connection object against a string variable here.