ADODB.Connection undefined
- by Wes Groleau
Reference http://stackoverflow.com/questions/1690622/excel-vba-to-sql-server-without-ssis
After I got the above working, I copied all the global variables/constants from the routine, which included
Const CS As String = "Driver={SQL Server};" _
& "Server=**;" _
& "Database=**;" _
…