Webstore, Open Microsoft Access database in SPSS version 21

I'm using SPSS and I'm trying to open an Access database in SPSS version 21. In previous versions the Open Database > Open Query lets you select the DB – in this case Access – and you have a window to enter the path to the file.

cannot mix 32 bit Microsoft Office with 64 bit SPSS if you want to use the Microsoft office ODBC drivers from within SPSS.

If you wish to use the 32 bit Microsoft Office software:

1. Install 32 bit MS Office including the 32 bit ODBC drivers
2. Install 32 bit IBM SPSS Statistics application
3. Setup DSN via the Datasource administrator (32-bit) or via SPSS/open database.

If you want to use the 64 bit Microsoft Office software:

1. Install 64 bit MS Office including the 64 bit ODBC drivers
2. Install 64 bit IBM SPSS Statistics application
3. Setup DSN via the Datasource administrator (64-bit) or via SPSS/open database.



Keywords:WebStore SPSS Office 32 bit 64 bit   Doc ID:56168
Owner:Vicki T.Group:University of Illinois Technology Services
Created:2015-09-12 19:02 CSTUpdated:2016-12-19 15:55 CST
Sites:University of Illinois Technology Services
Feedback:  0   0