SQLite Browser on Windows

From CDOT Wiki
Revision as of 22:02, 9 October 2013 by Jrromasanta1 (talk | contribs)
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 cmd(windows cmd or Mac terminal)

  1. http://hackgeo.com/foss/sqlite-how-to-import-csv