I'm trying to connect my Excel to Oracle with this connection string in VBA:

```
dim cn As New ADODB.Connection
cn.Open "Provider=OraOLEDB.Oracle;Data Source=source;User Id=userid;Password=pwd;"

```

I'm getting this error:

```
Run-time error '3706':
Provider cannot be found. It may not be properly installed.

```

Relevant references:

```
Microsoft ActiveX Data Objects 6.1 Library
OraOLEDB 1.0 Type Library

```

* Excel is MS Office Professional Plus 2010 64-bit
* Windows is 7 Enterprise, service pack 1, 64 bit
* Oracle client is 11.2.0 32 bit (I think)
* Oracle server is Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Now... I have scoured the net and cannot figure out what the issue is, but my best guess is there's some 32 bit vs 64 bit conflict with drivers I'm using. I'm trying to get a sense of what path I should be taking before I involve my company's IT department to try installing stuff for me. Does the Oracle client have to be 64 bit if MS Office is? Or do I just need the 64 bit Oracle Data Access Components? I've tried a bunch of different connection strings with no success, including using MSDAORA instead of OraOLEDB.Oracle...