Returning External Data to Spreadsheet

Specify the query and select Return Data to Statistica from the File menu to display the Returning External Data to Spreadsheet dialog box. Use these options to specify the name of the query and where you want Statistica Query to put the data that the query returns.

Name. Type a name for the query in the Name box. Note that this is the name that only Statistica will use internally to refer to this specific query. This name is useful, for instance, when you have connected multiple queries to one spreadsheet and therefore many queries are displayed in the Select Database Query dialog box. This name may or may not be the same name that you have specified for the query via the Save As option from the File menu; hence if you want to open the query in other applications, you would not use the name that is specified in this field. Instead, use the .sqy file name that is specified via the Save As option.

Where do you want to put the data? Specify New Spreadsheet if you want the data that the query returns to be placed into a new spreadsheet. Specify Active Spreadsheet starting at if you want the data that the query returns to be placed into the currently active spreadsheet in Statistica. If you choose the latter option, use the Variable and Case boxes to specify exactly where in the active spreadsheet you want the data to be placed. By default, the data will be placed at Variable 1, Case 1 (i.e., row 1, case 1 - the upper-left corner of the spreadsheet - see Spreadsheet Overview for further details). In this manner, it is possible to create multiple queries for an individual spreadsheet. Simply specify independent cells in which the data should be placed for each query. If you inadvertently specify overlapping cells, Statistica Query issues a warning.

Run now. Click this button to run the query and return to Statistica.

Edit. Click this button to return to Statistica Query and edit the current query.

Cancel. Click this button to exit from the Returning External Data to Spreadsheet dialog box and return to Statistica without running the query.

Properties. Click this button to display the External Data Range Properties dialog box in which you can specify options regarding the return of external data to spreadsheets.

Fit spreadsheet. Select this check box to ensure that the spreadsheet will be the same size as the size of data retrieved. You can have only one of this kind of query in a spreadsheet.

Maximum row. This option protects against accidentally writing a query that contains an unexpectedly large number of rows. Enter the maximum number of rows that the query will return at one time before prompting about the size of the query. If the number of rows in your query exceeds this value, you will be prompted to either cancel the query (retrieving the data read thus far), to read this many more rows (and be prompted again), or to retrieve the rest of the data without further prompting.

Save as global settings. Select this check box to save the current settings for future queries.

More. Click this button to display the External Data Range Properties dialog box for additional querying options.

Note: Connecting to external databases for streaming. The Get External Data option executes a user-defined query and copies the resulting data to your local computer. In other words, all data retrieved by the query is copied into a Statistica data file and stored locally. Alternatively, you can connect to external databases and retrieve particular sets of data via query without the need to create a local copy of the data. Specifically, in the Create New Document dialog box, select the Streaming DB Connector tab to create a connection to a database that will look to Statistica as if it were a regular data file.  In other words, when you use the streaming database connector options, the program does not first copy and store all data returned by the query on your local computer and then begin the analyses, but rather, the computer processes the database in place, only fetching the information from the database when it is needed for computations. Hence, streaming database connections are particularly useful and efficient when processing extremely large data sets (retrieved by a query from an external database), and they are commonly used in Data Mining applications. See also Streaming Database Connector Technology for additional details.