In this section i m going to explain how ms-excel data can be imported into sqlite database in android
1.First you must have an excel file which contains some data and save that file with ".csv " extension
2.Open Sqlite Manager and create a new database with a name and now go to Database tab--->New Database and enter your database name and save at your required location.
3.Now Again go to Database tab and select import option to import excel data to your database
4.Now on right side you will get a Edittext and select your required excel file that is saved in ".csv" extension and select First row contains column names
5.Now click ok and again ok.
6.See your table has been imported and you can do as you wish
1.First you must have an excel file which contains some data and save that file with ".csv " extension
2.Open Sqlite Manager and create a new database with a name and now go to Database tab--->New Database and enter your database name and save at your required location.
3.Now Again go to Database tab and select import option to import excel data to your database
4.Now on right side you will get a Edittext and select your required excel file that is saved in ".csv" extension and select First row contains column names
5.Now click ok and again ok.
6.See your table has been imported and you can do as you wish
No comments:
Post a Comment