O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required