TYPE Subcommand (GET TRANSLATE command)

TYPE indicates the format of the file.

• TYPE can be omitted if the file extension named on FILE is the default for the type of file that you are reading.
• The TYPE subcommand takes precedence over the file extension.
• You can create a Lotus format file in Multiplan and translate it to an active dataset by specifying WKS on TYPE.

WK . Any Lotus 1-2-3 or Symphony file.

WK1. 1-2-3 Release 2.0.

WKS. 1-2-3 Release 1A.

SYM. Symphony Release 2.0 or Symphony Release 1.0.

SLK. Microsoft Excel and Multiplan saved in SYLK (symbolic link) format.

XLS. Microsoft Excel. For Excel 5 or later, use GET DATA.

DBF. All dBASE files.

TAB. Tab-delimited ASCII data file.

Example

GET TRANSLATE FILE='PROJECT.OCT' /TYPE=SLK.

• GET TRANSLATE creates an active dataset from the Multiplan file PROJECT.OCT.