Microsoft Access 2010 Bible

Part III: More-Advanced Access Techniques

610

Microsoft Access is often described as a “landing pad” for many types of data. What this means is

that Access can use and exchange data among a wide range of applications. For example, you

might need to get data from other databases, such as FoxPro, or dBASE. Or you might need to

obtain information from SQL Server or Oracle, a text file, or even an XML document. Access can

move data among several categories of applications, database engines, and even platforms (main-

frames and Macintosh computers).

Open the Chapter17_1.accdb database in Access, and click the External Data ribbon tab (see

Figure 17.1). You’ll see the following groups: Import, Export, Collect Data, and Web Linked Lists.

FIGURE 17.1

The External Data tab hints at the variety of external data sources available to Access.

Import & Link group Export group Outlook data

collection

Links to

data on

the Web

The Import group includes the following options:

l (^) Saved Imports
l Linked Table Manager
l (^) Excel
l Access
l (^) ODBC Database
l Text File
l (^) XML File
l More: Click this button to open the More drop-down list, which has the following
options:
l SharePoint List
l (^) Data Services
l HTML document
l (^) Outlook folder
l dBase File