Beth Massi has been busy creating a number of great posts describing how to build add-ins to Excel, Outlook, Word, etc to work with data from an ADO.NET Data Service. The articles can be found here:
ADO.NET Data Services - Building an Excel Client
OBA Part 1 - Exposing Line-of-Business Data
OBA Part 2 - Building an Outlook Client against...