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 »
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.
Related InfoPath Articles:
- Display Access 2010 data in an InfoPath 2010 browser form
- Use an Access table as a secondary data source in a browser-compatible InfoPath form
- Bulk import InfoPath forms into an Access 2013 database
- Use an InfoPath form to perform CRUD actions on an Access table with Memo field
- 3 Ways to integrate InfoPath with SQL Server