MS SQL 2008 connection with VBA

maks25

New Member
Joined
Sep 8, 2011
Messages
30
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:


Code:
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
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Watch MrExcel Video

Forum statistics

Threads
1,090,462
Messages
5,414,662
Members
403,541
Latest member
J0hnJ

This Week's Hot Topics

Top