I have an Access database that I would like to link to an Excel file located on SharePoint. Normally, this is easy to accomplish as SharePoint/MS Office are well integrated.

The problem is, the Excel file in question is maintained by a contractor who uploads a different version each month, e.g., "inventory_jan", "inventory_feb", etc. -- which means that the URL/path of the latest data source is constantly changing.

Basically, I'm looking for some kind of automated solution that will retrieve the latest version of a file from a SharePoint document library where the file name is like inventory_*

  • interesting question, did you find a solution in the meantime? – MostlyHarmless Jul 19 '15 at 10:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.