How to connect to MS Dataverse using ADODB Connections in VBA

I have been successful in connecting to a MS SharePoint list in VBA with the following sub-routine:

Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim sConn As String
Dim sSQL As String
 
sConn = "Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;RetrieveIds=Yes;" & _
"DATABASE=https://<ORGANIZATION>.sharepoint.com/sites/<SITE>;" & _
"LIST={<LIST ID>};"

With cn:
    cn.ConnectionString = sConn
    Call cn.Open
End With

sSQL = "SELECT tbl.[<COLUMN NAME>] FROM [<LIST NAME>] as tbl;"
rs.Open sSQL, cn, adOpenStatic, adLockOptimistic
Application.ActiveSheet.Range("A2").CopyFromRecordset rs

I would now like to know how to connect to a MS PowerApps Dataverse table in my custom work environment, but can't find any documentation on this subject. Is this possible? I don't have access to any PowerApps APIs as my IT department disallows this. Basically I'm trying to find a connection string for a table in this environment below:

Any help is appreciated.

I have tried to look on connectionstrings.com for a suitable solution, but haven't come up with anything. I have also tried searching google using various keywords. Maybe I'm searching for the wrong thing.

Access to Dataverse is controlled via a central set of permissions, if your IT Group is blocking access it its API, its also blocked for your access to the TSQL endpoint. Additionally TSQL has to be enabled on Dataverse for you to access it (It can be disabled)

You can find information on how to connect here: https://learn.microsoft.com/en-us/powerapps/developer/data-platform/dataverse-sql-query.

I would recommend that, before investing a lot of time in VBA on it, check with SQL Management Studio first to make sure you can login and query. You can get that from here: https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

If you can login and query, you can construct the connection string using the same data you input into the Management Studio,

You should keep in mind that Dataverse TSQL requires AAD Authorization to login. Make sure you take the time to read though this https://learn.microsoft.com/en-us/sql/connect/ado-net/sql/azure-active-directory-authentication?view=sql-server-ver15 as to which provider to use and how to form the connection string.