How import txt file in sqlite?

how can we import data in sqli开发者_如何学JAVAte with a sqlite's txt file as a backup? Is it better to use a xml file?

SQLlite database files are portable, there's no particular reason to dump them to text only to reimport them into a database except if you need something human-readable.

Maybe you mean to import a CSV file (Comma-Separated Values).

I suggest this way!

http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles