Publish Excel 2007 data to SharePoint then display it in InfoPath

In this InfoPath video tutorial you'll learn how to publish an Excel 2007 table to SharePoint as a SharePoint list and then use a Repeating Table in InfoPath to display the Excel data through a data connection with the SharePoint list.

The method shown in the video below is a dynamic method for changing data in an Excel spreadsheet, and having those changes replicate to all InfoPath forms that are connected to the SharePoint list for that Excel spreadsheet.

You can also use a static method to display data from an Excel spreadsheet in an InfoPath form through an XML file.

Before you begin, you must download and install the Excel 2007 Add-in: Synchronizing Tables with SharePoint Lists.

In this InfoPath video tutorial, you learned…

See more InfoPath 2007 tutorial videos »

 
 Subscribe via RSS or Email

Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced in any way without an expressed written consent of S.Y.M. Wong-A-Ton. The techniques demonstrated in this article may be used within any Microsoft InfoPath project. This article is provided without any warranties. Copyright for this article is non-transferrable and remains with the author, S.Y.M. Wong-A-Ton.

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners
InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013
InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners
InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010
InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers
InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services


Related Posts

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners

InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013

InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners

InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010

InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers

InfoPath 2010 Cookbook 4: 101 Code Recipes for VB Developers

InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services