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!