Donald,
After a small change ("" to '') for the .separator command, everything
worked very well.
Thanks for taking the time to respond,
Lee Crain
__________________________________________________
-----Original Message-----
From: Griggs, Donald [mailto:[EMAIL PROTECTED]
Sent: Monday, August 13, 2007 2:34 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Need To Export A Table From a SQLite Database as a
TAB Character Delimited Text File
Hi Lee,
Regarding: ...I need to export a table from a SQLite database as a TAB
character delimited text file.
Try the following
.separator "\t"
.output ExportFile.txt
select * from MyTable;
.output stdout
--------------------------------------------------------------------------
---
To unsubscribe, send email to [EMAIL PROTECTED]
--------------------------------------------------------------------------
---
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
