Re: Copy Data from Excel rows into Infopath Repeating Table

Hilary Stoupa — Fri, 19 Feb 2010 15:56:55 GMT

Hi:

I don't know of a simple way to do this... but I wonder about this solution suggested by the InfoPath team might be a workaround for you? An Access DB linked to the Excel sheet could provide a secondary data source to the form?

Of course, then you'd have the issue of trying to get the data from the secondary data source into your main data source, which would require code (or qRules for a codeless solution).

Copy Data from Excel rows into Infopath Repeating Table

ninnist — Mon, 15 Feb 2010 14:35:23 GMT

Hi,

I have a simple form where I gather some information into a repeating table and it all works.

The user often prepares the data in EXCEL and copies/pastes the information from EXCEL into the appropriate fields and there are 20 fields.

Is there a simple way to import the data through a control into the table starting from the currently highlighted row without having to upload the file?

Filling the fields from the Copy/Paste Clipboard may be acceptable (Open EXCEL, Copy all cells, Open InfoPath, select insertion point in table, Paste From Buffer)

Any clues on the most sensible way to do this?

Code

Re: Copy Data from Excel rows into Infopath Repeating Table

Copy Data from Excel rows into Infopath Repeating Table