There are a number of ways you can do this.
Select Open from the File menu to access the Open dialog.
Select an Excel file and click the OK button. In the Opening file dialog, click the Import selected sheet to a Spreadsheet button.
In the Select Sheet to Import dialog, select the Excel sheet you want and click the OK button.
The Open Excel File dialog is displayed.
This dialog provides different options for importing an Excel file.
Click the OK button to open the Excel file as a STATISTICA Spreadsheet.
Yes. STATISTICA Query (including options to combine fields from multiple tables) is provided via both the File - Get External Data and the BI menus. As long as the database format supports a 32-bit ODBC driver or an OLE DB provider, accessing such data should present no problem.
Yes, STATISTICA Enterprise offers options to query and access large remote data files in-place (i.e., without having to import the data and create a local copy).
Yes, via STATISTICA Query, an external data querying facility available from the Data - Get External Data submenu and the File - Get External Data submenu. The STATISTICA Query interface includes options to combine fields from multiple tables and provides flexible access to a wide variety of database management files, including the major enterprise database formats such as Microsoft SQL Servers and Oracle. Specific records (rows of tables) can be selected by entering SQL statements. STATISTICA Query automatically builds the SQL statement for you as you select the components of the query via a simple graphical interface. Hence, no extensive knowledge of SQL is needed to create queries of data.
STATISTICA Extract, Transform, and Load (ETL) provides the capability to process data from standard databases (Microsoft SQL® , Oracle® ) as well as specialized process databases (e.g., OSI Pi®), with data filtering, alignment, and aggregation.
Disparate sources can be aligned by batch number and time interval and/or by one or more ID fields. Merging many-to-one data sets is a common scenario.
Yes. SAS binary files from SAS versions 6.08 through the current version can be imported by STATISTICA.
STATISTICA can export data files to a wide variety of Windows and non-Windows applications via the Save As command accessible from the File menu. You can even save spreadsheets as formatted and free format text (ASCII) files. These facilities allow you to specify the exact way in which the translation is to be performed (e.g., decide whether to export variable names, text labels, and case names). Also, STATISTICA Spreadsheets are OLE servers and clients, so other applications can link to them.