Loading ODBC drivers from the Microsoft Data Access Pack

Steve Simon


[StATS]: Loading ODBC drivers from the Microsoft Data Access Pack (created 2001-01-24)

Here are excerpts from some emails posted to the SPSSX-L listserver on September 10-11

drivers for ODBC

First message: If the application is ODBC compliant

include most modern database programs

Driver 32. The SPSS Data Driver allows ODBC compliant applications to read SPSS system files directly

included in the SPSS Data Access Pack on the SPSS 10.0 CD-ROM. To install the driver

should appear. Click on Install SPSS Data Access Pack. At the first screen


installed. Then click Next. At the Select Components screen

box next to SPSS Data Driver 32. Then

remaining steps in the wizard. This will install the SPSS Data Driver into your ODBC Data Sources Control panel.

To configure the driver

Double click on Data Sources (ODBC). On the User DSN tab

Scroll down until you see SPSS Data Access 32 (*.sav)

Click Finish. A small dialog box will appear

next to Data Source: type in a name for the Data Source. In the box next to Database: type in the full path to the directory where you SPSS data file is located. Then click OK. Click OK again on the Database Administrator. When you use the data source within your application

directory as a separate table. In general

variables at a time. —–Original Message—– Sent: Friday, September 08

data into Access ??

Second message: On the SPSS 9.0 CD-ROM

Pack (which includes the Microsoft Access ODBC Driver) is in the folder called “ODBC Drivers”. Double click on the file called dataacc.exe to install.

You can also download the Microsoft Data Access Pack directly from Microsoft’s webpage

www.microsoft.com/data. They call it the Microsoft Data Access Components

Third message: I also found a copy on the Access 97 CD. I knew it had to be somewhere on the SPSS CD but after searching the SPSS web site to no avail I then tried Microsoft’s site (no luck) and then the Access disc. I told it to reload Access using the Add/Remove feature and found the driver that way. The trick seems to be know what to call something (like “data access pack”) when roaming around discs & web sites.

Fourth message: You need the driver for the application that contains the data. Since the data are in Access 97

Access ODBC driver. (If the data were in SPSS

ODBC driver.) Microsoft ODBC drivers are located in the system subdirectory of your windows directory. The file names begin with ODBC and have a .DLL extension. If they have been wiped out or corrupted, you can reinstall them by reinstalling Access. The following technical note contains related information that may be useful. support.microsoft.com/support/kb/articles/Q237/5/75.ASP.

This page was written by Steve Simon while working at Children’s Mercy Hospital. Although I do not hold the copyright for this material

or Category: SPSS software. this one at Category: Data management with general help resources. You can also browse for pages similar to Children’s Mercy Hospital website. Need more information? I have a page reproducing it here as a service