Agriesean
Agriesean

Reputation: 155

How import txt file in sqlite?

how can we import data in sqlite with a sqlite's txt file as a backup? Is it better to use a xml file?

Upvotes: 1

Views: 2995

Answers (2)

Luca Davanzo
Luca Davanzo

Reputation: 21528

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

I suggest this way!

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

Upvotes: 0

Pedantic
Pedantic

Reputation: 5022

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.

Upvotes: 1

Related Questions