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…')
 
 
(2 intermediate revisions by the same user not shown)
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 using command line (windows cmd or Mac terminal)'''
 +
#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