Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » Troubleshooting UltraLite


Importing ASCII data into a new database


You have created a new UltraLite database, but have a .csv ASCII data file that you cannot import.


The .csv format is not supported by any of the UltraLite administration tools.


You can try one of the following techniques:

  • Use Interactive SQL (dbisql) to import the data. You can connect to the UltraLite database and then choose Data » Import Data. Alternatively, you can connect to the UltraLite database and run the INPUT statement (this statement cannot be used in an UltraLite PreparedStatement object).


    UltraLite requires primary keys. Although Interactive SQL can create the table for you, it does not automatically create the primary keys for them. Always connect to an empty UltraLite database you have created for this purpose.

  • If you to incorporate this functionality as part of a batch process, you must write your own code.

See also