How To Import Database SQLite From Excel File

How To Import Database SQLite From Excel File

Hello friends, in this post I will discuss about how to import SQLite database from Excel file with extension .CSV. Before that I have prepared an excel file with some data in it

After that, open the Mozilla Firefox browser type sqlite manager firefox in the search field, then add the add-ons named SQLite Manager.

Wait until the installation process is complete. When finished, click the Tools menu, it will appear a new sub menu SQLite Manager. click that sub menu, it will appear SQLite Manager dialog box.

Then click the Database menu, then select New Database. Enter the name of your database and specify the storage location. Next, click the Import button on the toolbar

then click the Select File button and select the Excel file you have set up and check the "first row contains column names" checkbox as shown below

Click Ok, then specify table name, column name and data type

When done, you can see the results as shown below

Powered by Blogger.