<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>General</title><link>https://www.infopathdev.com:443/forums/41.aspx</link><description>If 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.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Submitting Multiple Items to SharePoint List with Excel Data Source</title><link>https://www.infopathdev.com:443/forums/thread/103145.aspx</link><pubDate>Tue, 07 Jul 2015 16:54:38 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:103145</guid><dc:creator>JackSki</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/103145.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=103145</wfw:commentRss><description>&lt;p&gt;I have an Excel list with about 2,500 items. I need to take that list and submit those items to a SharePoint list. Currently, I have a REST connection set up to the Excel file. It appears to crap out if I go above 500 items (using a Range specified in connection). I&amp;#39;m trying to push 500 items at a time to SharePoint list (upon submit). Can this be done without code? &lt;/p&gt;&lt;p&gt;&amp;nbsp;Things I&amp;#39;ve tried: SOAP connection and Batch file. Problem is I can&amp;#39;t seem to populate the batch XML with data from the Excel REST connection.&amp;nbsp;&lt;/p&gt;&lt;p&gt;I&amp;#39;ve seen the Wong-A-Ton methods for bulk upload, but those do one item at a time, unless you&amp;#39;re using code, which I currently don&amp;#39;t have access to. I was thinking there might be a way to neatly bring in and display the REST connection Excel data and then copy it to the XML Batch file fields, even if I have to create 500 placeholders in the batch file.&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;Is what I want to do possible?&amp;nbsp; &lt;br /&gt;&lt;/p&gt;</description></item></channel></rss>