This article shows an example of how to connect an external MS Access database and query the data back to Statistica. This instruction should also apply to various database types other than MS access with small modification. 

1.Select HOME|Open|Open External Data|Create Query…

2.Select an existing database connection if you already have one. Otherwise, click “NEW” to create a new one(for illustration purpose, click "NEW")

3.Select either the OLE DB provider that was supplied by your database vendor, or one of the Microsoft default OLE DB providers compatible with your database system. And then click “NEXT”

Note: You have to have the same bit type of MS Access and Statistica installed (both 64 or both 32) 

4.Type in information of the data source and server login under the Connection tab in “Data Link Properties” dialog and then click “Test Connection”. Note: the MS access data file extension needs be added in the Data Source field, e.g. C\File\database\Access_Database01.accdb

5.If the connection is set up correctly, the following message will pop up. Otherwise, check the filled information in step 4 and repeat step 5

6.Click “OK” in the above message box when step 5 is accomplished and in the “Data link Properties” dialog of step 4

7.When the “Add a Database Connection” dialog appears, type a name (e.g. "test_wx") for the connection and click “OK”

8.The new connection's name will display in the “Database Connection” dialog. Click “OK”

9.Statistica Query window will appear

10.Build your data query by dragging tables from the left list to the right blank board. To select a variable, click the variable name under the dragged tables on right;Certain query tools are available on the top bar. Note: click the "switch mode" (highlighted in black rectangular) to switch querying mode between Graph mode(drag and draw) and Text Mode(write sql scripts)

11.To preview the data, Click "Preview Data" or select other actions from the panel at bottom

12.Click the green arrow button(in the red circle of the figure) to return the queried data as a Statistica spreadsheet.

Note: More information about database connection is available at Statistica e-manual sessions such as “Working with STATISTICA Query” or “Advanced Database Access Tools”