Reader Level:
ARTICLE

Import HTML File in Our Access 2013 Database

Posted by Richa Garg Articles | Office 2013 September 03, 2012
In this article I will explain how to import a HTML file into Access 2013.
  • 0
  • 0
  • 3146

In my previous article I explained how to generate a HTML file using Access 2013. In this article I explain how to import a HTML file into Access 2013. To do so first follow the instruction in my previous article then use the following steps.

Step 1

Open the Access 2013 and select blank database and give the name of your database as "CreateDatabase" and then click "Create", as in:

Create-Database-In-Access-2013.jpg

Step 2

Go to the External Data menu option then select "HTML Document" from the "More" option, as in:

Import-Html-File-In-Access-2013.jpg

Step 3

A window is shown in this window click on the Browse button to select your previously created HTML file, as in:

Get-Html-Document-In-Access-2013.jpg

Now select your file from the window that is shown.

Select-Html-Document-File-In-Access-2013.jpg

After selecting your file click ok.

Step 4

A window is shown; click next in this.

Window-Open-In-Access-2013.jpg

Then it will ask for the field names; provide the field names then click next as in:

Give-Field-Name-In-Access-2013.jpg

Now select each row and give the name of each field and click next.

Step 5

Now this document is placed in the right hand side of the access 2013 as:

Html-Document-In-Access-2013.jpg

Step 6

Select this file and the database looks like:

Output-In-Access-2013.jpg

Summary

In this article I explained how to import the HTML file into Access 2013.

COMMENT USING

Trending up