Importing ASCII data into a new database

Symptom

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

Explanation

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

Recommendation

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).

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

See also