To create an ODBC connection in VBA, two things are required:
What I'd like to know is if OLEDB has fewer requirements and is easier to implement.
OLEDB is the way to go as you'll probably be using ADODB for your queries etc.