I receive an error stating "java.sql.SQLException: No data found" when trying to open a Microsoft Access database from SPSS Text Analysis for Surveys.

Resolving The Problem

If you try to set up the data source from within SPSS Text Analysis for Surveys (STAfS) by using the generic access driver that is not already set up for a specific .mdb file, you will receive the error mentioned (no data). In other words, if you choose File->Import->ODBC, and the choose the "MS Access Database" DSN, it will fail.

However, if you use the ODBC Data Source Administrator to set up the DSN before hand, then you should be able to import the data without a problem. You can access the ODBC Data Source Administrator by clicking the ODBC button in the Select ODBC Data Source dialog box that comes up when you choose File->Import->ODBC.

To set up an Access database in the ODBC Data Source Administrator follow the procedure below:

1) Choose either the User DSN (visible only to the currently logged in account) or System DSN (visible to any account that logs in to this computer) tab and click the Add button.
2) Choose the "Microsoft Access Driver (*.mdb)" driver and click finish.
3) In the ODBC Microsoft Access Setup dialog, enter a name for the data source and an optional description.
4) Click the select button, find the mdb file and select it, then click OK.
5) Click OK in the ODBC Microsoft Access Setup dialog.
6) Finally, click Apply if it is available, then OK in the ODBC Data Source Administrator.

You should now see the data source you created in the Select ODBC Data Source dialog box. Select your newly created data source and click next. You can then select the table or write a SQL query and click next.

Finally, assign the Unique ID variable, Open Ended Text variable and any Reference variables and click next.

Your data should now be displayed in the Text Analysis view