SQLite Browser on Windows

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