Alison Balter's Mastering Access 97 Development, Second Edition

Chapter 19. Using External Data

• Understanding External Data

• Importing, Linking, and Opening: When and Why

• Importing External Data

• Creating a Link to External Data

• Opening an External Table

• Understanding Windows Registry Settings

• Using the Connection String

• Working with Passwords

• Refreshing and Removing Links

• Creating an External Table

• Looking At Special Considerations

• Troubleshooting

• Looking At Performance Considerations and Links

• Working with HTML Documents

• Practical Examples: Working with External Data from within Your Application

Understanding External Data

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