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