Load Formats

Load format support differs between Adaptive Server Enterprise, SQL Anywhere, and Sybase IQ.

Sybase IQ handles ASCII, BINARY, and BCP load formats.
SQL Anywhere, in addition to ASCII and BINARY, also lets you import dBase, Excel, FoxPro, and Lotus file formats.
Adaptive Server Enterprise handles ASCII and BINARY load formats through BCP.

Note: The syntax of the Sybase IQ and SQL Anywhere LOAD statement is based on BCP and designed to offer exactly the same functionality.