In Excel, I need to populate an ADO 1

[SBendBuckeye]

In Excel, I need to populate an ADO recordset of exception data which is based on a query in an Access database. Do I need to instantiate an Access Application object to retrieve the data or can I use ADO by itself to do this?

If someone could point me, I would be grateful! Thank you!

Have a great day!

j2consulting@yahoo.com

 

[Bastien]

Generally the DB needs to be running, so I would say yes.

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!

 

[Jables]

You don't need to instantiate the Access application. You can use ADO to connect to the database via ODBC.

Dim oConn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim strSQL As String

Set oConn = New ADODB.Connection
Set rst = New ADODB.Recordset
Set oConn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"
strSQL = "SELECT * FROM MyTable"
rst.Source = strSQL
rst.ActiveConnection = oConn
rst.CursorType = adOpenDynamic
rst.CursorLocation = adUseServer
rst.Open

Hope this helps.

 

[SBendBuckeye]

Thank you Jables! That is exactly what I was looking for!

Have a great day!

j2consulting@yahoo.com

 

[SBendBuckeye]

Check out this link also:

http://www.connectionstrings.com/.

Have a great day!

j2consulting@yahoo.com

 

[Jables]

Haha, that's where I got the connection string that's in my post.