CHAPTER 6
Importing and Exporting Data

---

IN THIS CHAPTER

• Understanding external data
• Selecting the import and export options that are right for you
• Creating import specifications
• Exporting to external tables and files

---

In this chapter, we show you how to bring data into your Access database from an outside source by importing. We also show you how to create external files from the data by exporting. An import process adds data to an Access database from some external source, such as an XML file. An export from Access means you create something outside the Access database, like an XML or Excel file containing data stored in Access.

---

ON THE WEB

This chapter uses various files for importing, plus two Access databases: Chapter06_1.accdb and Chapter06_2.accdb. Both databases are used for importing and exporting examples. The tables from the completed imports have been renamed in the files. If you haven't already downloaded these files onto your machine from this book's...