Jamie Collins wrote:
"Provider=msdaora;Data Source=MyOracleDB;" & _
"User Id=myUsername;Password=myPassword"

I seem to remember Oracle's own OLEDB provider being preferred to
Microsoft's version.

Interesting - I remember hearing the opposite some time ago. But when I
google it now, I get conflicting results on which provider is better.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]