CODEWITHSUNDEEP
excelvbaodbcoledb
sooprise
sooprise

Reputation: 23187

VBA Easier To Implement, ODBC vs OLEDB?

To create an ODBC connection in VBA, two things are required:

  1. Create a ODBC data source
  2. Add references in Excel

What I'd like to know is if OLEDB has fewer requirements and is easier to implement.

Upvotes: 1

Views: 1242

Answers (1)

Raj
Raj

Reputation: 1770

OLEDB is the way to go as you'll probably be using ADODB for your queries etc.

Upvotes: 1

Related Questions