Bulk import InfoPath forms into an Access 2013 database

Watch this demo video of how you can import InfoPath 2013 forms that were downloaded from a form library in SharePoint 2013, into two Access 2013 database tables by automating the import using a macro in Access.

The following InfoPath 2013 with Access 2013 video demonstrates how you can download InfoPath forms that are stored in a SharePoint form library, and then use a macro to automate the process of importing the downloaded InfoPath forms into an Access 2013 database.

InfoPath 2013 with Access 2013 video tutorial transcript

Here I'm in SharePoint 2013, where I've already published an InfoPath form template to this SharePoint form library, which as you can see currently contains 3 InfoPath forms.

If I open the first form, you'll see that it is a simple InfoPath form that has these 2 text box controls on it containing customer information, a number and a name in this case, and this repeating table control containing addresses for the customer. So customer number 1 has 2 addresses. If I open the second form, you'll see that customer number 2 has 3 addresses, and if I open the third form, you'll see that customer number 3 has only 1 address.

In recipe 121 of InfoPath 2013 Cookbook 2, you'll learn how to manually import one InfoPath form into an Access database. If you want to automate the process of importing InfoPath forms into an Access database and import multiple InfoPath forms at the same time into an Access database like I want to do with these 3 InfoPath forms, you'll have to write code.

So what I want to do next is, I want to download these 3 InfoPath forms to a folder locally on disk. And for that I'm going to be using this Open with Explorer command to open the SharePoint form library in Windows File Explorer and make it easier for myself to copy the InfoPath forms to a folder that is located locally on disk.

Once you've opened the SharePoint form library, all you have to do then is select the forms, copy them, and here I'll switch to the folder I'll be using to import the InfoPath forms, I'll paste the InfoPath forms in there, and then I'll switch to my Access database.

As you can see here, I've got just these 2 tables. If I open the Customer table, you'll see that it has these 2 fields. And these 2 fields will be filled with the data from the text boxes on the InfoPath forms. I also have this Address table, in which I'll be storing the addresses, and each address will be linked to a customer via this CustomerNo field.

So all I have to do now is double-click this macro to run it. Once it has run, I'll open the Customer table. And as you can see, we've got the data here from the 3 InfoPath forms. And when I open the Address table, you'll see the addresses listed from each customer. So customer 1 had 2 addresses, customer 2 had 3 addresses, and customer 3 had 1 address.


Related InfoPath Articles:


Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced in any way without an expressed written consent. The techniques demonstrated in this article may be used within any Microsoft InfoPath project. This article is provided without any warranties. Copyright for this article is non-transferrable and remains with the author.