O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

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

Creating OLE Links

If you want to import a file that might change later, you might be better off creating a dynamic link to that file than importing it outright. With a link in place, if the file changes later, the changes will be reflected in the file imported into Access.

It's Slower

Don't use this procedure unless you are sure you need a link, rather than a simple import. Having a link in your database slows Access down when it opens a file.

Follow these steps to create a table in Access that's linked to an external file:

  1. Select File, Get External Data, Link Tables. The Link dialog box appears.

  2. Change the drive or folder if necessary.

  3. Select the file type from the Files of type drop-down list.

  4. Double-click the file name to open the file ...

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