CODEWITHSUNDEEP
androidsqlitecsv
user3452123
user3452123

Reputation: 1

Reading CSV from assets then Insert Data into SQLITE

I want to insert data of CSV file from assets folder in SQLite in android. How do I accomplish the task effectively and efficiently?

Upvotes: 0

Views: 385

Answers (1)

Ando Masahashi
Ando Masahashi

Reputation: 3122

use FireFox Browser and install SQLITE-MANAGER plug-in

follow few steps.

1.create new database with appropriate name

2.Goto>file> select import

3.now Goto select file navigate to your csv file and select that file

4.select first raw as column name if you set in csv.

5.create it. now save this file ad DB and use it in your project

6.you file this kind of window.

enter image description here

or you can do it programmatically

follow this link

Upvotes: 2

Related Questions