Load Formats

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

SAP 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 SAP Sybase IQ and SQL Anywhere LOAD statement is based on BCP and designed to offer exactly the same functionality.