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
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
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
Code:
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