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:
Select File, Get External Data, Link Tables. The Link dialog box appears.
Change the drive or folder if necessary.
Select the file type from the Files of type drop-down list.
Double-click the file name to open the file ...
Get Ten Minute Guide to Access 97 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
