How to Connect SQL Express 2005 from VBA?
Here is a way to connect to SQL Express 2005 from Excel VBA Sub Connect2SQLXpress() Dim oCon As ADODB.Connection Dim oRS As ADODB.Recordset Set oCon = New ADODB.Connection oCon.ConnectionString =… Read more »