General

Re: Importing data from Excel to Infopath Forms

Patrick Halstead — Tue, 02 Sep 2008 21:59:19 GMT

http://www.infopathdev.com/blogs/david/archive/2008/07/16/excel-to-xml-automatically-generating-infopath-forms-from-excel-data.aspx

Re: Importing data from Excel to Infopath Forms

Clay Fox — Tue, 18 Sep 2007 20:17:51 GMT

Is this a one time process or does this import need to be done on a regular basis and automatically?

One way would be to save the excel as XML and then recieve the xml via a data connection and then map the data from Excel(XML) to your form XML. The fields would contain the information and only certain fields would show on a given view.

Otherwise you should have SQL Express and import Excel to a SQL table. This can be completely automated with a DTS script or the excel sheet can pull its data directly from SQL and it can be the central storage location. Then you form can interact with the data from SQL. You may want to look at the Database Accelerator if you choose to store your data in SQL. Qdabra Database Accelerator Suite Version 2.1.2815 - Developer

Importing data from Excel to Infopath Forms

tcsqa_engineer — Tue, 18 Sep 2007 17:06:13 GMT

Hi All,

I have a data in Excel, that I would like to import to a Infopath Form. The Form has multiple views.

How will I Import the data from Excel to the Infopath and make sure that the data gets populated into the relevant fields.

Thanks much.

Rajeev.