Chapter 16. Sharing Data

In this chapter

  • Export data to Excel and import Excel data into Access

  • Export and import to text files

  • Publish Access reports to Word

  • Use Word’s mail-merge with your Access names and addresses to create several letters at once

  • Send Access data via email

Access is much more than just a database. It’s part of the best suite of computer software on the market. Access, Word, and Excel all work well together, which means data that’s entered in one application can be used in another.

Most of the time, you’ll find Excel or Word just a button click away. The OfficeLinks button on the Database toolbar offers three options:

  • Merge It with MS Word

  • Publish It with MS Word

  • Analyze It with MS Excel

But there’s more. You can import data into Access, ...

Get Absolute Beginner’s Guide to Microsoft® Office Access 2003 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.