The following figure
provides a logical view of using Microsoft Access as a data source
and connecting to the database with a
SAS/ACCESS ODBC interface.
Setting up a connection
from SAS to a Microsoft Access database by using ODBC is a three-stage
process:
-
Define an ODBC data
source.
-
Register the database
server.
-
Register the database
library.
This example shows the
process for establishing a SAS connection to an Access database. It
assumes that the software for the database has already been loaded
with the standard installation wizard for the database client. In
addition,
SAS/ACCESS Interface
to ODBC must be installed on the SAS server that will access the Access
database.