Unanswered: Importing Excel Files from Sharepoint site sub folder.
So I am trying to connect a time tracking tool which i created to the pipeline. the pipeline is maintained on Sharepoint under a sub folder. I want to establish dynamic link between the pipe and the tool, so when a user has fields pre populated from the details from the pipe.
Essentially, when the time tracker tool is capturing info on the time taken on an activity, i would like be able to tie in the details such as project title, turnaround time on a project, project sponsor etc.
What is the easiest way to do this?
P.S. - I am using Access 2007 and Excel 2007. Secondly i do not have admin rights on the SharePoint.
Hope this is enough, let me know if you need more info?