Newbie Questions

Re: How to Import/Merge data from Excel to InfoPath?

istern — Tue, 09 Jun 2009 16:56:06 GMT

Hi,

You can paste multiple columns from Excel into InfoPath 2007 Client but if you load the form in a browser it doesn't work, is there any way to paste multiple rows / columns into a browser InfoPath form?

TIA

Re: How to Import/Merge data from Excel to InfoPath?

istern — Tue, 09 Jun 2009 16:55:15 GMT

Normal 0 false false false EN-US X-NONE HE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}

Hi,

TIA

Re: How to Import/Merge data from Excel to InfoPath?

Barto — Wed, 19 Sep 2007 20:09:08 GMT

Dont know if it plays a role, but then target fields are plain non-repeating fields...

Thanks in advance

Re: How to Import/Merge data from Excel to InfoPath?

Barto — Wed, 19 Sep 2007 16:37:02 GMT

Thanks for your info. Guess the first solution would b preferable.

I'm using InfoPath 2003 - Don't know if it makes any difference...

/Barto

Re: How to Import/Merge data from Excel to InfoPath?

Greg Collins — Wed, 19 Sep 2007 16:23:59 GMT

There is a way to establish an Excel file to be XML/Schema based... and then you might be able to create a data connection to that file. I don't know all the ins-and-outs of it, but I'm sure someone does and has done it before.

Another possibility is this: If you have an Excel file with, say, 5 columns and X rows, and your InfoPath form has a repeating table with 5 columns, you can copy and paste the Excel data into InfoPath. The ony requirement is that you first insert the correct X number of rows in your repeating table before pasting in the Excel data. InfoPath (at least the 2007 version) will correctly past each Excel cell into the appropriate repeating table cell. It may not be ideal--but it could get you by until you find something better.

Good luck!

How to Import/Merge data from Excel to InfoPath?

Barto — Wed, 19 Sep 2007 15:46:55 GMT

I've got an infopath form, that consist of step 1, 2, 3..etc.

Step 2 is in an Excel(xml) file - Is it posible to import the data from the excel file to an open infopath form?

Regards Barto