SQLTeam.com | Weblogs | Forums

Requirement to populate column values in excel

sql2008r2

#1

I need to write a stored procedure which will be used to generate an excel report where three columns should be populated ie.

Document Name, Document Uploaded on, Document Uploaded by

To populate these column values in excel, I need point to a SharePoint repository or location where the pdf or excel files are stored which are uploaded by the users.

The most recent or latest modified file properties such as Document Name, Document uploaded by will be populated as these three columns in excel.

Please guide me like how the file properties such as Document Name etc. at a SharePoint repository address can be accessed by the query which is used to generate the excel report.