extracting data from sharepoint
I'm programmatically creating a spreadsheet using VB.NET. The code
gets the data from a sharepoint document library. right now i'm using a web query: With sheet.QueryTables.Add(Connection:= _ "URL;https://www.xxx.com/sites/xxx/xxxx/xxx/AllItems.aspx" _ , Destination:=sheet.Range("a1")) this works, but i need to insert some SQL into the query to limit the number of records. How would i figure out the syntax? all the examples i can find are for SQL Server, not a SharePoint library. would i be better off using a SharePoint Web Service? thanks in advance! |
extracting data from sharepoint
Hello,
You have posted your question to an Infopath newsgroup by mistake. Try one of the Sharepoint newsgroups. I believe this would be possible using the Sharepoint SDK (http://msdn2.microsoft.com/en-us/library/bb693438.aspx), so you might try that resource before reposting to the sharepoint groups. Gavin. "steve" wrote: I'm programmatically creating a spreadsheet using VB.NET. The code gets the data from a sharepoint document library. right now i'm using a web query: With sheet.QueryTables.Add(Connection:= _ "URL;https://www.xxx.com/sites/xxx/xxxx/xxx/AllItems.aspx" _ , Destination:=sheet.Range("a1")) this works, but i need to insert some SQL into the query to limit the number of records. How would i figure out the syntax? all the examples i can find are for SQL Server, not a SharePoint library. would i be better off using a SharePoint Web Service? thanks in advance! |
All times are GMT +1. The time now is 10:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com