BO VBA 6.5.1: Is it possible to use ADODB objects? How?

[Former Member]

Hi.

I'd like to reuse code I already have in Excel VBA with my BO VBA project. Excel VBA understands references to ADODB for accessing external SQL datasources (ADODB.Connection, ADODB.Command, ADODB.Recordset, etc.). BO VBA apparently doesn't. How can I make it work?

Thanks in advance.

[Former Member]

Looks like I answered myself. Just need to use

Set var = CreateObject("ADODB.Connection")