I am trying to determine the best method to copy data from an Excel spreadsheet inot my infopath repeating table. Is it best to export the Excel data as an xml or just cut/paste. I was using the ExecuteAction /action=XCollectionInsert /xmltoedit=group10_195 command but i would like to insert more than one row at a time. In some cases, I may want to copy/insert 50+ lines at a time.
Import from Excel is not officially supported by InfoPath, but you can copy and paste into a repeating table and it will work for the most part. You'll have to be careful that your clipboard matches the destination schema (eg. same number of columns -> same data types) or you may run into problems.