Difference between revisions of "SQLite Browser on Windows"
Jrromasanta1 (talk | contribs) |
Jrromasanta1 (talk | contribs) |
||
(One intermediate revision by the same user not shown) | |||
Line 11: | Line 11: | ||
− | '''Importing CSV file into table''' | + | '''Importing CSV file into table using command line (windows cmd or Mac terminal)''' |
#http://hackgeo.com/foss/sqlite-how-to-import-csv | #http://hackgeo.com/foss/sqlite-how-to-import-csv |
Latest revision as of 22:03, 9 October 2013
- Download and Install SQLite Browser (Windows platform) [1]
- SQLite Browser - Overview [2]
- Generate a CVS file on generatedata.com.
- Run SQLite Browser
- Create a database. Choose a descriptive database name such as FriendsDB.
- Import a table from a CSV file.
- Save the database
- Testing
- 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)