开发者

VBA Easier To Implement, ODBC vs OLEDB?

开发者 https://www.devze.com 2022-12-31 19:30 出处:网络
To create an ODBC connection in VBA, two things are required: Create a ODBC data source Add references in Excel

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 开发者_如何学Pythonimplement.


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

0

精彩评论

暂无评论...
验证码 换一张
取 消