SQLite Browser on Windows

From CDOT Wiki
Jump to: navigation, search
  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