https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/21700.aspxMon, 16 Jul 2007 18:19:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:21700Clay Fox0https://www.infopathdev.com:443/forums/thread/21700.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=21700<p>You may want to look at having your Excel file be a data connection for your IP form.&nbsp; 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. </p><p>You can export from IP to Excel but some of the copy and paste I think is difficult.&nbsp; 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.</p>https://www.infopathdev.com:443/forums/thread/21694.aspxMon, 16 Jul 2007 16:21:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:21694jeagly0https://www.infopathdev.com:443/forums/thread/21694.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=21694<p class="MsoNormal" style="margin:0in 0in 0pt;">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.</p><p class="MsoNormal" style="margin:0in 0in 0pt;">&nbsp;</p><p class="MsoNormal" style="margin:0in 0in 0pt;">Thanks!</p>