Chapter 17. Using Excel with Access

[ LiB ]

Chapter 17. Using Excel with Access

Just as easily as Excel and Word interact, so do Excel and Access. Both Excel and Access work with data in rows and columns which makes it seamless to transfer data between the two applications.

In this chapter, you'll learn how to:

• Export Access data into Excel

• Import Excel data into Access

• Create a link from an Excel worksheet to Access

NOTE

If you are not familiar with using Microsoft Access, you should consider purchasing Microsoft Office Access 2003 Fast and Easy, ISBN 1-59200-078-9

[ LiB ]