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.

Disregard. I was not aware that the connection string was the default property of the connection object and could be accessed by using only the object name instead of "object name dot property" (strConn.ConnectionString).

Good to know info. Thanks for sharing!