Import to excel from accdb access table held in Sharepoint

[Molden]

Hi all,

I have an access table that I query through excel. I know have to move the access table to our office 365 sharepoint

It was held on a shared drive which I queried like below

Sub TestImport()

Dim cn As Object
Dim rs As Object
Dim strSQL As String
Dim strConnection As String
    
    Set cn = CreateObject("ADODB.Connection")
    
    strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
        "Data Source=\\MML.LOCAL\MyDocs\Michael.Smith\Documents\Radio\London UPRNS.accdb"
  
    strSQL = "SELECT Count(*) FROM [London UPRNs];"
    
    cn.Open strConnection
    Set rs = cn.Execute(strSQL)
    
    MsgBox rs.Fields(0) & " rows in MyTable"

    rs.Close
    Set rs = Nothing
    cn.Close
    Set cn = Nothing


End Sub

The URL to where my database will be held is here:

MML.sharepoint.com/sites/team_bi/_layouts/15/guestaccess.aspx?guestaccesstoken=pR2oimbiNon7zdAV8lNAZ9OWrnpk7f0ACJlnxRAKyM8%3D&docid=2_11aab497dad404d70b9240b2561424a40&rev=1&e=bd9e55f437644c4282d695790842bd29

Does anyone know of a way I can change my code to incorporate the databases change of location?

I am using Excel / Access 2016 and the database is saved to office 365 sharepoint.

Thank you in advance