Difference between revisions of "SQLite Browser on Windows"

From CDOT Wiki
Jump to: navigation, search
(Created page with '# Download and Install SQLite Browser (Windows platform) [http://sourceforge.net/projects/sqlitebrowser/] ## SQLite Browser - Overview [http://sqlitebrowser.sourceforge.net/] # G…')
 
Line 8: Line 8:
 
#Testing
 
#Testing
 
## Close and Restart SQLite Browser. Open the database that you have just created.
 
## Close and Restart SQLite Browser. Open the database that you have just created.
 +
 +
 +
 +
'''Importing CSV file into table'''
 +
#http://hackgeo.com/foss/sqlite-how-to-import-csv

Revision as of 23:01, 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

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