Connect Excel to Access - VBA

Question

I get a "User-defined type not defined" error when I execute the below code, and the

"objCon As ADODB.Connection"

is highlighted on the first line. I am trying to set a connection from Excel to Access via VBA code. Thank you for any advice!

Private objCon As ADODB.Connection Private rstRec As ADODB.Recordset Private strQry Sub Connect() Dim strConn As String Set objCon = New ADODB.Connection objCon.Mode = adModeReadWrite If objCon.State = adStateClosed Then strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & "C:\DB\Db.accdb;Persist Security Info=False;" objCon.ConnectionString = strConn objCon.Open End If End Sub

Hi, have you add ActiveX inside Tools->reference? support.microsoft.com/kb/257819 — Larry
– Larry, Commented Dec 17, 2012 at 8:17
Oh my, that was it, it worked! Fabulous. Please add as an answer so I can add points for you. — Sam
– Sam, Commented Dec 17, 2012 at 8:25
I suggest closing the question, this question has been asked many time before, you can search for VBA ADODB REFERENCE on SO or Google to find the solution. :) — Larry
– Larry, Commented Dec 17, 2012 at 8:27
can you see share|edit|close|delete|flag above the comments? the delete If not I can make it as an answer.. — Larry
– Larry, Commented Dec 17, 2012 at 8:30

Larry · Accepted Answer · 2012-12-17 08:36:42Z

You can do one of the following

set objCon = CreateObject("ADODB.Connection") set rstRec = CreateObject("ADODB.Recordset")

Or in VBA Editor Tools-->Reference--> Add Microsoft ActiveX Data Object X.Y Library

Collectives™ on Stack Overflow

Connect Excel to Access - VBA

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related