Database Reference
In-Depth Information
In the
Items to import
column, for each of the selected lists, select the view
(arrangement of data) you want to import into the database.
7
With the
Import display values instead of IDs for fields that look up values stored
in another list
check box selected, click
OK
.
TROUBLESHOOTING
No progress bar appears while Access imports the lists, and
this process can take some time. Resist clicking the OK button more than once.
8
When the last page of the wizard appears, click
Close
. Or choose to save the import
steps, provide the necessary information, and then click
Save Import
.
9
After you import or link to a list, you should open the resulting table in Datasheet view to
verify that all of the fields and records were imported and that there were no errors. You
can review the data type and other field properties by switching to Design view.
Importing from .html files
HTML is used to create webpages. It uses tags to control the appearance and alignment of
the content displayed in a web browser. For a table to display correctly on a webpage, the
table's rows and cells must be enclosed in appropriate HTML tags. For example, a simple
HTML table might look like the following.
...<table><tr> <td>LastName</td><td>FirstName</td></tr> <td>Anderson</td>
<td>Nancy</td></tr></table>...
In an .html file, the <table>, <tr> (table row), and <td> (table data) tags and their corre-
sponding </table>, </tr>, and </td> end tags make the data look like a structured table
when it is viewed in a web browser.
10
All the Office 2013 programs can save a document in HTML format, and to a limited extent,
they can read or import a document that was saved in HTML format by another program.
When you import an .html file into Access, the program scans the document and identifies
anything that looks like structured data. You can then evaluate what Access has found and
decide whether to import it.
