Chapter 3. Populating a Database

Chapter at a Glance

Populating a Database

In this chapter, you will learn to:

Import information from another Access database.

Import information from an Excel worksheet.

Import or link to a SharePoint list.

Collect data through e-mail.

Import information from a text file, an XML file, an HTML file, or a dBASE file.

Import information from an Outlook folder.

Not many people enjoy typing information into a database table, so an important goal when designing a relational database is to structure the tables in such a way that the database user never has to enter the same information more than once. If, for example, you are designing ...

Get Microsoft® Office Access™ 2007 Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.