How can I access data from excel and other foreign data files?

Clipboard. The quickest, and in many cases easiest, way to access data files from other Windows applications (e.g., spreadsheets) is to use the Clipboard, which in STATISTICA supports special Clipboard data formats generated by applications such as Microsoft Excel. For example, STATISTICA properly interprets formatted cells (such as 4/17/1999 or $10) and text values (including extensive in-cell formatting, e.g., RVStower120.3MHz).

File import facilities. Data files from a wide variety of Windows and non-Windows applications can be accessed and translated into the STATISTICA format using the file import facilities (by opening the file using the File - Open command). You can even access formatted and free format text (ASCII) files.

The main advantages of using the file import facilities (over the Clipboard) are that:

  • You can specify the exact way in which the translation is to be performed (e.g., access named ranges in the foreign data files; decide whether or not to import variable names, text labels, and case names; and how to interpret them), and

  • You can access types of data that are not (or not easily) accessible to Clipboard operations (such as missing data codes).

See Importing Data for further details.

STATISTICA Query. In addition to the file import facilities described above, STATISTICA provides access to virtually all databases via STATISTICA's flexible STATISTICA Query, accessible from both the File - Get External Data and the Data - Get External Data menus. For more information see STATISTICA Query.

OLE Links. STATISTICA supports the Object Linking and Embedding (OLE) conventions allowing you to link values or text in STATISTICA documents (e.g., spreadsheets, reports) to documents in other (Windows) applications. The procedure is in fact much simpler than it might appear and can be easily employed without technical knowledge about the mechanics of OLE, especially when you use the Paste Link (instead of script-entry) method. See How do I set up OLE links between STATISTICA and other Windows applications? and OLE Links for further details.

DDE links. Finally, STATISTICA supports the Dynamic Data Exchange (DDE) conventions; thus, you can dynamically link a range of data in a spreadsheet to a subset of data in other (Windows) applications. Like OLE, the procedure is in fact much simpler than it might appear, and can be easily employed without technical knowledge about the mechanics of DDE. To set up a DDE Link, select DDE Links from the Edit menu. See How do I set up DDE links between STATISTICA and other Windows applications? and DDE Links for further details.

Accessing datafiles larger than the local storage. Note that enterprise versions of STATISTICA offer options to query and access large remote data files in-place (i.e., without having to import the data and create a local copy).

See also, Opening Document Objects in STATISTICA.