Difference between revisions of "SQLite Browser on Windows"

From CDOT Wiki
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 11: Line 11:
  
  
'''Importing CSV file into table'''
+
'''Importing CSV file into table using command line (windows cmd or Mac terminal)'''
 
#http://hackgeo.com/foss/sqlite-how-to-import-csv
 
#http://hackgeo.com/foss/sqlite-how-to-import-csv

Latest revision as of 23:03, 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 command line (windows cmd or Mac terminal)

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