Open main menu

CDOT Wiki β

SQLite Browser on Windows

Revision as of 23:02, 9 October 2013 by Jrromasanta1 (talk | contribs)
  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