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 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.