Difference between revisions of "SQLite Browser on Windows"

From CDOT Wiki
Jump to: navigation, search
Line 11: Line 11:
  
  
'''Importing CSV file into table'''
+
'''Importing CSV file into table using cmd(windows cmd or Mac terminal)'''
 
#http://hackgeo.com/foss/sqlite-how-to-import-csv
 
#http://hackgeo.com/foss/sqlite-how-to-import-csv

Revision as of 22:02, 9 October 2013

  1. Download and Install SQLite Browser (Windows platform) [1]
    1. SQLite Browser - Overview [2]
  2. Generate a CVS file on generatedata.com.
  3. Run SQLite Browser
    1. Create a database. Choose a descriptive database name such as FriendsDB.
    2. Import a table from a CSV file.
    3. Save the database
  4. Testing
    1. Close and Restart SQLite Browser. Open the database that you have just created.


Importing CSV file into table using cmd(windows cmd or Mac terminal)

  1. http://hackgeo.com/foss/sqlite-how-to-import-csv