A.17 Statements for Importing and Exporting Data

Table A-28, "Statements for Importing and Exporting Data" lists the OLAP DML statements that you use to import and export data.

Table A-28 Statements for Importing and Exporting Data

Statements	Description
EXPORT	Copies both data and object definitions from your workspace to an EIF file, or copies an OLAP DML worksheet object to a spreadsheet file.
IMPORT	Copies data from an EIF file, a text file, or a spreadsheet into an analytic workspace.
WKSDATA	Returns the data type of each individual cell in a worksheet.
SQL	Typically, used in a program to copy data to and from relational tables, passes instructions written in Structured Query Language (SQL) to the relational manager from Oracle OLAP.