InfoPath Dev

What is the best way to copy and past from excel into a repeating table in IP and visa versa. I have tried converting my text box to a rich text box. I need to be able to past several rows into a repeating table. The only thing I can think of is to first add the number of rows that need pasted and then copy from excel and past to IP, but it all gets pasted into the first rich text box.

Thanks!

You may want to look at having your Excel file be a data connection for your IP form.  Or better yet use SQL or SQL express on the backend and have your Excel use the data from there and have your IP form use the data from SQL too.

You can export from IP to Excel but some of the copy and paste I think is difficult.  You may want to look at getting the data in SQL or evaluating if you really need Excel or could you do it all with an IP form and save alot of moving data back and forth.