On 9/1/06, Rich Shepard <[EMAIL PROTECTED]> wrote:
Is there a command to bulk load data (in comma and quote format) into a table? I'd hate to copy 180 lines x 31 attributes by individually.
The ".import" command of the command line program that comes with sqlite works. If you need something that doesn't do check out my program, see the links below. You should also check out a text editor that has macros and regular expression search and replace. 180 lines isn't much harder than 2 with good tools -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
