Re: [sqlite] Problem with .import -- SOLVED

On Fri, 29 Sep 2006, Dennis Cote wrote: When all else fails, the source is the ultimate documentation. :-) Dennis, True. True. Thanks, Rich -- Richard B. Shepard, Ph.D. |The Environmental Permitting Applied Ecosystem Services, Inc.(TM)|Accelerator

Re: [sqlite] Problem with .import -- SOLVED

Rich Shepard wrote: I tried to find documentation on the .import command (and the other metacommands), but couldn't. Nothing about them in Mike Owens' book, the man page, or a Google search. This must be one of the pieces of knowlege that's passed from generation to generation only when

Re: [sqlite] Problem with .import -- SOLVED

On Thu, 28 Sep 2006, Dennis Cote wrote: I suspect you may have trailing spaces at the ends of your lines. The .import command isn't very smart about things like that. Your separator is set to one space, not arbitrary whitespace. It there is another separator after the last field it assumes