Importing ASCII data into a new UltraLite 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 click 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).

Note

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 incorporate this functionality as part of a batch process, you must write your own code.