O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

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

Linking Versus Importing

You can work in Access with data from other programs in two ways: You can import it or you can link it.

When you import a table, as you just did, you are awarding it full Access citizenship. In other words, it becomes indistinguishable from any other table in your database. The source document, whether residing in another Access database or an external environment such as Excel, is left untouched and unaffected by any changes you make in your new Access table.

By contrast, a linked table attains only expatriate status in Access—it remains a citizen of its native program. You can view and edit the data of the linked table and even create a query based on it. However, you can't alter how the table and its fields are defined ...

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