Summary

In this chapter we've concerned ourselves purely with data from outside of the current database - what it is, where it is, and how to use it. We've looked at how we can use data from other sources, as well as supplying data to other sources. This is quite a common request, and you've seen that the programming required for this is fairly simple.

In particular we've looked at:

• How to import and export text files, spreadsheets, and database objects

• How to export to XML, and to generate web reports using this technique

• How to send electronic mail, incorporating data from Access

• How to use other data sources, whilst keeping the original source of the data

Now that we've got all of this data into Access, it's about time to see how reports can make it easier for us to view it.