Difference between revisions of "SQLite Browser on Windows"

From CDOT Wiki
Jump to: navigation, search
 
Line 11: Line 11:
  
  
'''Importing CSV file into table using cmd(windows cmd or Mac terminal)'''
+
'''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 22: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