Home
Hans Muster's Library tagged → View Popular
Beth Massi - Sharing the goodness that is VB : ADO.NET Data Services - Building an Excel Client
Today I want to show a simple Excel client that queries our service and allows us to edit the customers in Northwind. I'm going to use Visual Studio 2008 (VSTO) to build a document-level customization against an Excel 2007 Workbook. We'll also build an Actions Pane that allows us to query and save customers to our ADO.NET data service. Excel's tabular data format lends itself well to CRUD database operations when we Add, Delete and Update rows in a Sheet. (NOTE: You cannot create Office solutions in Visual Studio Express editions.)
Excel 2007 can now do two-way sync to a SharePoint List
In Excel 2003 you were able to sync amendments both from a Excel 2003 spreadsheet to a SharePoint List and from a SharePoint List to an Excel 2003 spreadsheet. But in Excel 2007 this is no longer the case... Well it was until Microsoft released an Excel 2007 Add-in. This is a must install if you are upgrading to Office 2007 from Office 2003, otherwise your users will cry.
Microsoft Office SharePoint Server 2007 products comparison download - Help and How-to - Microsoft Office Online
Included in this document is a complete breakdown of the features of Microsoft Office SharePoint Server 2007 and a comparison between the different 2007 server editions and SharePoint Portal Server 2003.
Selected Tags
Related Tags
Sponsored Links
Top Contributors
Groups interested in excel
-
CC_spreadsheets
Resources utilized in Compu...
Items: 5 | Visits: 57
Created by: Chris Wherley
-
Excel
Resources for Excel and spr...
Items: 12 | Visits: 243
Created by: drew polly
Highlighter, Sticky notes, Tagging, Groups and Network: integrated suite dramatically boosting research productivity. Learn more »
Join Diigo