Connecting To a Excel Database

[NOODLES101487]

Hi All, Im pretty new to vba programming Ive developed simple vb apps i
the past but never needed to connect to a database.

What do I need to do setup the connection, Ive currently got this in m
code and throws up an error message:

Dim cn as ADODB.Connection
Set cn = New ADODB.Connection
With cn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=C:\MyFolder\MyWorkbook.xls;" & _
"Extended Properties=Excel 8.0;"
.Open
End With

When I try to run it I get the error: User defined type not define
for the ADODB.Connection so I havnt set this up correctly I have MDA
2.5 already installed so what else do I need to setup.

Thanks in Advance

 

[David Lloyd]

Your error message is likely cause because you do not have a reference set
up for the Microsoft ActiveX Data Object (ADO) library in your project. In
the Visual Basic Editor, select References from the Tools menu and add a
reference for this library.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


in message
Hi All, Im pretty new to vba programming Ive developed simple vb apps in
the past but never needed to connect to a database.

What do I need to do setup the connection, Ive currently got this in my
code and throws up an error message:

Dim cn as ADODB.Connection
Set cn = New ADODB.Connection
With cn
..Provider = "Microsoft.Jet.OLEDB.4.0"
..ConnectionString = "Data Source=C:\MyFolder\MyWorkbook.xls;" & _
"Extended Properties=Excel 8.0;"
..Open
End With

When I try to run it I get the error: User defined type not defined
for the ADODB.Connection so I havnt set this up correctly I have MDAC
2.5 already installed so what else do I need to setup.

Thanks in Advance.