Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 
Simplify SQL Server Database Development     ====>    Webcast Registration
 

Convert Excel Forms into InfoPath Forms


By:   |   Read Comments   |   Related Tips: > Sharepoint

Problem

There may be times when users have created forms in Excel or Word, but we need them in SharePoint in a web-based version. How can I handle that easily using InfoPath? (read more...)

Solution

The solution is to use InfoPath's import feature which can convert forms from Excel/word.

I have an Excel form which looks like the following:

purchase order

Now open an instance of InfoPath 2007 and you can see an option of "Import a form". Click on it.

recently used forms

You will be prompted for a destination type from where you want to import a form. It could be either an Excel or Word form. For now, select "InfoPath importer for Excel workbooks"

import wizard

Click on Browse to select the Excel form file.

import wizard

Click on options, to customize the default options (for instance, whether you want to detect repeating tables or not, to convert cells containing formulas to textbox and others). For now, leave the default settings and click OK.

import options

Click on 'Finish' and now you can see that InfoPath has created a similar kind of structure and relative fields in the form structure.

purchase order

This is a great method of having your users design a form in a tool they are familiar with, while minimizing your development time.

Next Steps


Last Update:


next webcast button


next tip button



About the author
MSSQLTips author Rahul Mehta Rahul Mehta is a Project Architect/Lead working at Tata Consultancy Services focusing on ECM.

View all my tips





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools