9.5. Migrating Your Existing Excel Workbook into InfoPath

As with MS Word forms, you may have existing forms in Excel that you want to use with InfoPath. Or maybe you found the perfect form template on Microsoft's template website, but the site only had an Excel version of it. In either case, you definitely do not want to re-create that form from scratch. So how can you import that Excel workbook into InfoPath without starting from a blank form?

I'm going to start with an Excel form template downloaded from Microsoft's site named Donation Receipt, which is shown in Figure 9-13. While this form is fairly simple, it demonstrates the concepts needed to convert an Excel template to an InfoPath form. The original version of this form template includes ...

Get Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.