What is needed to open an ODBC connection with VBA?

I want to query a Deltek GCS database. I would like to supply the query inside of my VBA code, instead of invoking a query on the cloud that I am connecting to.

1. Is there a function to create an ODBC connection?
2. What parameters will I need to supply besides userid and password?

The database I need to connect to runs on a cloud. I want to open an ODBC connection, provide a query, and drop the answers in cell A1 of the first tab.

How do I do this? What parameters will I need to supply?

Here is what I am currently using:

Please Login or Register  to view this content.

Do I have to set up a User DSN or a System DSN? If so, how do I do that? When I click "Add" I see a list of drivers, but I don't see the name of the database/data source that I need to connect to which is 'GCSPremier.'

Please help.

What is your code doing, or not doing, that doesn't work for you? I really only have experience doing this through .NET, so I can't be of TOO much help here. But I did find this article on setting up a DSN

http://exceltoolset.com/how-to-creat...dbc-using-vba/