You can import your data into SPSS Statistics with a standard SQL query. The SPSS Database Wizard can automatically generate and execute an appropriate query based on parameters you specify.
The following procedure is written for SPSS Statistics 23. Simba ODBC drivers also support earlier versions of SPSS.
Make sure that the bitness of the driver that you are using matches the bitness of SPSS. If you are using the 32-bit version of SPSS, then you need to use the 32-bit version of the driver. If you are using the 64-bit version of SPSS, then you need to use the 64-bit version of the driver. For more information about diagnosing the issue, see Architecture Mismatch Problems.
To retrieve data using SPSS:
Data retrieved from the selected tables is displayed in SPSS Statistics in a new Dataset window. You can now use SPSS Statistics to analyze the data.
For more information about connecting to a database in SPSS Statistics, see the SPSS Statistics Help documentation that is provided in the application.