I have built a spreadsheet which imports and exports data to a data base using the below vba to connect to the database
Set cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Ace.OLEDB.12.0; " & _
"Data Source=\\ntfiler1\Service_Design\PMT\DatabaseProce ssManagement.accdb;"
I wish to store the database on a sharepoint and so I changed the Data Source to the URL address of the sharepoint stored database, however this does not work, how can I connect to a database that is stored on sharepoint and be able to connect to it to transfer data to and from the database from an execl sheet.
Thanks