Hi All,
i have been using this forum for many years to find answers to questions and problems I've had when it came to excel.
Today I've come with a query which I hope someone may be able to answer.
Situation: Currently there are reports that are upload to a sharepoint site as CSV files. These reports will fall under 4 different categories so will have different sets of data, but they will have common columns (i.e. Office, Site ID, etc).
Once uploaded another set of reports (5 in total), will pull data from the CSV files located on the sharepoint site.
What I am trying to do at the moment is pull data from these CSV files on the sharepoint site into an excel file. I can do it if they are locally saved, but is there a way to pull the data from the CSV files without having to download them first, bearing in mind there are 100s of files so having to download each one for every user will be impractical.
I hope someone can help, please!
Regards,
Shak.
i have been using this forum for many years to find answers to questions and problems I've had when it came to excel.
Today I've come with a query which I hope someone may be able to answer.
Situation: Currently there are reports that are upload to a sharepoint site as CSV files. These reports will fall under 4 different categories so will have different sets of data, but they will have common columns (i.e. Office, Site ID, etc).
Once uploaded another set of reports (5 in total), will pull data from the CSV files located on the sharepoint site.
What I am trying to do at the moment is pull data from these CSV files on the sharepoint site into an excel file. I can do it if they are locally saved, but is there a way to pull the data from the CSV files without having to download them first, bearing in mind there are 100s of files so having to download each one for every user will be impractical.
I hope someone can help, please!
Regards,
Shak.