Open main menu

CDOT Wiki β

SQLite Browser on Windows

Revision as of 22:03, 9 October 2013 by Jrromasanta1 (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
  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