I am trying to create a mobile app using flex-mobile flash builder 4.6, which shows three ComboBoxes. I am reading values from a local SQLite built-in database. I want to insert bulk values in my database viz. from a csv/text file. Any idea,how should I go about it? Thanks in Advance, Chris
Asked
Active
Viewed 151 times
1 Answers
0
Run sqlite3.exe your_database_file.db
and execute
.mode csv your_table_name
.import your_csv_file your_table_name

Alexander Farber
- 21,519
- 75
- 241
- 416
-
Thanks, this is a great help. Although I want to import the csv file programmatically from my app because then it can be packaged along with the application. – very fast Nov 27 '13 at 15:46