I am using SQLite build-in import command for importing records from text files.

The code being follows:

$ sqlite3 dbname.db
SQLite version 3.1.3
Enter ".help" for instructions
sqlite> .separator "\t"

Once I have set the field separator, I do import:

sqlite> .import filename.txt tablename

This solves my purpose but have any one tried on any user-defined function to import data to sqlite.