SQLite Batch Import

 Keywords:  SQLite Batch Import

Need to get 45,000+ Zipcodes from a tab-delimited file into an SQLite db - batch it.

Requires sqlite3.exe which is part of the free download. http://www.sqlite.org/index.html

The attached zip contains the tab-delimited file and a script which creates both a test.sql file [import spec] and test.bat [used via runwait()].

It only took ~2 seconds to complete and the script continues by using the SQLite ODBC driver to list the first 10 zips in North Carolina.

Article ID:   W18198

Filename:   SQLite Batch Import.txt

File Created: 2019:08:14:09:27:30

Last Updated: 2019:08:14:09:27:30