Microsoft® Office Access™ 2007 Plain & Simple

Importing Data from Another Access Database

One way to think of an Access database is as a collection of facts about a particular subject. For example, you could have a database that tracks your sales contacts and correspondence, another database that tracks your product inventory, and yet another that tracks your vehicles and the miles they drive. It makes sense to separate your data into topic-based databases, but there are times when a table from one database is useful in another database. For example, if you want to use data from a table in a database that’s hosted on another computer, consider importing that data into your own database to guard against the network being down or the database being unavailable. Access 2007 also lets you save ...