title: ADODB connection to an Excel file on SharePoint
body: <p>I'm trying to get a adodb connection to a file on SharePoint (we have sharepoint 2013 as I know) to retrieve and upload some data to it from another excel file on my local drive.
  I can do it when these two files are on my local drive with simple adodb connection, opening and so on. But I don't understand how to do the same with DB file being uploaded to SP.</p>
  
  <p>I need some help to understand how to make it work.</p>
  
  <p>I know I can open file from SP using VBA but in this case I can't make a adodb connection to it.<br>
  Thanks  </p>