Data Analysis with Microsoft Excel: Updated for Office 2007

74 Excel

formatted the data values in a table and added AutoFilter buttons to

fi lter the data if you so desire.

Figure 2-29

Data

retrieved

from the

Wheat

database

Unlike importing from a text fi le, you can have Excel automatically re-

fresh the data it imports from a database. Thus, if the source database

changes at some point, you can automatically retrieve the new data without

recreating the query. Commands like refreshing imported data are available

from the Connections group on the Data tab. Table 2-6 describes some of

these commands.

Table 2-6 Commands on the Data tab

Button Icon Purpose

Refresh All Refresh all data queries located in the

current workbook

Connections View and modify the properties of all the

data connections in the workbook

Properties View and modify the properties of the

currently selected data range

Having seen how one would import data from a database into Excel, you

are ready to save and close the workbook.

To save and close the Wheat workbook:

1 Click the Offi ce button and then click Save As

2 Type Wheat Database in the File name box, verify that Excel Workbook

(*.xlsx) is displayed in the Save as type box, and then click Save.