To create an ODBC connection in VBA, two things are required:
- Create a ODBC data source
- 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.
精彩评论