User Guide

24
Chapter 3
E
Follow the instructions for creating a new query.
To Read Data
base Files with Saved Queries
E From the me
nus choose:
File
Open Database
Run Query...
E
Select the query file (*.spq) that you want to run.
E Depending on the database file, you may need to enter a login name and password.
E If the query has an embedded prompt, you may need to enter other information (for
example, the quarter for which you want to retrieve sales figures).
Selecting a Data Source
Use the first screen to select the type of data source to read. After you have chosen
thefiletype,theDatabaseWizardmaypromptyouforthepathtoyourdatafile.
Ifyoudono
t have any data sources configured, or if you want to add a new data
source, click
AddDataSource. In distributed analysis mode (available with the server
version), this button is not available. To add data sources in distributed analysis
mode, see y
our system administrator.
Data sources. A data source consists of two essential pieces of information: the driver
that will be used to access the data and the location of the database that you want to
access. T
o specify data sources, you must have the appropriate drivers installed. For
local analysis mode, you can install drivers from the CD-ROM for this product:
 SPSS Data Access Pack. Installs drivers for a variety of database formats.
Availabl
e on the AutoPlay menu.
 Microso
ft Data Access Pack.
Installs drivers for Microsoft products, including
Microsoft Access. To install the Microsoft Data Access Pack, double-click
Microsoft Data Access Pack in the Microsoft Data Access Pack folder on the
CD-ROM.