Import InfoPath data into Access database tables

Watch a demo video of how you can import data from InfoPath form fields into one or more tables in a Microsoft Access database.

This InfoPath video is a demonstration of how you can go about importing data from an InfoPath form into Access database tables.

InfoPath 2010 video transcript:

Here I'm in Access 2010 where I've got this database that contains these two tables. The first table is a Customer table in which the names of customers should be stored, and the second table is an Address table in which address lines of customers should be stored.

I also have this InfoPath form which I've already pre-filled with data and I would like to import the data from this InfoPath form into the two Access database tables where I would like to place the customer information in the Customer table and these address lines in the repeating table into the Address database table.

The way you go about importing InfoPath form data into Access is via this External Data tab. Click on XML File. And then browse to and select the InfoPath form you want to import. Click OK. And then I'll select to append data to existing tables, because the tables already exist in my database. And then I'll transform the data using an XSL stylesheet. Click OK. Click OK. Click Close. And that is the entire process for importing the data from the InfoPath form into the Access database tables.

So now if I open these tables we should see the customer information listed in the Customer table and the two address lines for the customer listed in the Address table.

See more InfoPath 2010 tutorial videos »

 
 Subscribe for updates via RSS or Email

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 of S.Y.M. Wong-A-Ton. 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, S.Y.M. Wong-A-Ton.

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners
InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013
InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners
InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010
InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers
InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services


Related InfoPath Articles:

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners

InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013

InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners

InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010

InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers

InfoPath 2010 Cookbook 4: 101 Code Recipes for VB Developers

InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services