MS SQL 2008 connection with VBA

[maks25]

Hi,

I am looking to connect to a Microsoft SQL Server 2008 db with VBA and pull data with SQL.

I would be using Windows Authentication.

I've tried googling but couldn't find any MS SQL SERVER 2008 specific guides on how to do so.


I've found this but I am not sure I understand how it works:

Sub Connect2SQLXpress()


Dim oCon As ADODB.Connection
Dim oRS As ADODB.Recordset
Set oCon = New ADODB.Connection
oCon.ConnectionString = "Driver={SQL Native Client};Server=.\SQLEXPRESS;Database=DB1; Trusted_Connection=yes;"
oCon.Open
Set oRS = New ADODB.Recordset
oRS.ActiveConnection = oCon
oRS.Source = "Select * From Table1"
oRS.Open
Range("A1").CopyFromRecordset oRS
oRS.Close
oCon.Close
If Not oRS Is Nothing Then Set oRS = Nothing
If Not oCon Is Nothing Then Set oCon = Nothing


End Sub

I've substituted "DB1" for the db name and ".\SQLEXPRESS" for the server name yet I'm getting an error stating that I do not have the required driver.

I did enable the MS ActiveX Objects 2.8 Library

I'm using Excel 2010

Thanks