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