TYPE Subcommand (GET DATA command)

The TYPE subcommand is required and must be the first subcommand specified.

ODBC. Data sources accessed with ODBC drivers.

XLS. Excel 95 through Excel 2003 files. For earlier versions of Excel files, Lotus 1-2-3 files, and dBASE files, see the GET TRANSLATE command.

XLSX and XLSM. Excel 2007 files. Macros in XLSM files are ignored. XLSB (binary) format files are not supported.

TXT. Simple (ASCII) text data files.