Microsoft Office Tutorials and References
In Depth Information
Importing External Data
To set up an either/or condition in the Custom AutoFilter dialog box, you
normally choose between the “equals” and “does not equal” operators (which-
ever is appropriate) and then enter or select the first value that must be met
or must not be equaled. Then you select the Or option and select whichever
operator is appropriate and enter or select the second value that must be
met or must not be equaled.
For example, if you want to filter the data list so that only records for the
Accounting or Human Resources departments in the Employee Data List
appear, you select “equals” as the first operator and then select or enter
Accounting as the first entry. Next, you click the Or option, select “equals”
as the second operator, and then select or enter Human Resources as the
second entry. When you then filter the database by clicking OK or pressing
Enter, Excel displays only those records with either Accounting or Human
Resources as the entry in the Dept field.
Importing External Data
Excel 2013 makes it easy to import data into a worksheet from other
database tables created with stand-alone database management systems (such
as Microsoft Access), a process known as making an external data query .
You can also use web queries to import data directly from various web pages
containing financial and other types of statistical data that you need to work
with in the Excel worksheet.
Querying Access database tables
To make an external data query to an Access database table, you click the
From Access command button on the Ribbon’s Data tab or press Alt+AFA.
Excel opens the Select Data Source dialog box where you select the name
of the Access database and then click Open. The Select Table dialog box
appears from which you can select the data table that you want to import
into the worksheet. After you select the data table and click OK in this dialog
box, the Import Data dialog box appears.
The Import Data dialog box contains the following options:
✓ Table to have the data in the Access data table imported into an Excel
table in either the current or new worksheet — see Existing Worksheet
and New Worksheet entries that follow
✓ PivotTable Report to have the data in the Access data table imported
into a new pivot table (see Chapter 9) that you can construct with the