Chapter 10. Import and Export Data

Chapter at a Glance

Import and Export Data

In this chapter, you will learn how to

Import information.

Export information.

Copy to and from other Office programs.

From the moment you set out to create a database, you have to think about how you will manage its data. Good database design saves keystrokes when you’re entering new information and maintaining the database. But when you are populating a database, you can save even more time and effort in another way: by importing data from existing files in other formats.

When you import information into a Microsoft Access 2010 database, the data being imported usually needs to match certain ...

Get Microsoft® Access® 2010: Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.