|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Hi,
When programming in vb.net i always used the OLEDB class to connect to my
SQL database. eg. with something like:
Dim objConnection as New OleDbConnection( ConnectionString )
I noticed this does not work in Excel/VBA, here i used:
Set connection = New ADODB.Connection
connection.Open ConnectionString
My questions: #1 Whats the difference between OleDB and ADODB ?
#2 why do i need a set statement in VBA together with the Dim statement?
thanks,
Frank
|
|
|