Click here to go to the Office Update Home page   All Products  |   Support  |   Search  |   microsoft.com Guide  
Featured on Office UpdateMicrosoft
   Home   |    Auto Update   |    What's New   |    Search Office Update   |    eServices   |    Office Update Worldwide   |    Site Help   |
 
Table of Contents

With Access 2000 Should You Import or Link External Data?

What Is Importing?

What Is Linking?

With Access 2000 Should You Import or Link?

With Access 2000 How Do You Import or Link Data?

With Access 2000 How Do You Improve Performance with Linked Tables?

Importing and Linking: Additional Resources
  

With Access 2000 Should You Import or Link External Data? Click here to email this to a friend.

There are times when the data you want to work with is outside Microsoft Access, but you want to get it into Access so you can capitalize on the application's many useful features. To use external data with Access, you can either import it or link to it.

Access can work with data from a variety of different sources, including:

  • dBASE and Paradox databases.
  • Microsoft Excel spreadsheets.
  • Lotus 1-2-3 spreadsheets (linking is read-only).
  • Microsoft Exchange and Microsoft Outlook®.
  • Delimited and fixed-width text files.
  • HTML.
  • Other Access databases and Access projects.
  • ODBC data sources, such as SQL tables, Microsoft Visual FoxPro®, and any other programs and databases that support the ODBC protocol.
    
 
é

© 2000 Microsoft Corporation.
All rights reserved. Terms of use.  Disclaimer.