Connect to OLEDB..?

[Kent Johnson]

Hi all,

I usually link tables from a datasource via ODBC but now I have a SAS OLEDB
datasource.
How can I connect to a OLEDB-datasource from Access?

/Kent J.

 

[Douglas J Steele]

You can't as a linked table, but you can open an ADO recordset in VBA code,
assuming you know the appropriate connection string to use to connect.

 

[Kent Johnson]

OK!
How can I use ADO to connect to a OLEDB datasource?

/Kent J.

 

[Douglas J. Steele]

See, for example,
http://msdn.microsoft.com/library/en-us/dnado/html/workshp2.asp

Doing a Google search on ADO should also result in thousands of hits.