Alison Balter’s Mastering Microsoft Access 2002 Desktop Development

Chapter 19. Using External Data

<feature><title>In This Chapter</title>

• Importing, Linking, and Opening Files: When and Why 804

• Importing External Data 807

• Creating a Link to External Data 811

• Opening an External Table 820

• Understanding Windows Registry Settings 822

• Using the Jet OLEDB:Link Provider String 823

• Working with Passwords 823

• Refreshing and Removing Links 825

• Looking at Special Considerations 828

• Troubleshooting 829

• Looking at Performance Considerations and Links 830

• Working with HTML Documents 830

</feature>

Why This Chapter Is Important

Microsoft Access is very capable of interfacing with data from other sources. It can use data from any OLEDB or ODBC data source, as well as data from FoxPro, dBASE, Paradox, Lotus, Excel, and many other sources. ...