On Tue, 24 Aug 2004, Marc Pitoniak wrote:
>I understand that the "Copy" command is no longer available in sqlite3.
It was felt it was redundant.
>
>Is there anything comparable to "Copy" that will allow me to import text
>files using an sql statement from my program?
>
>Putting it another way, using sqlite3.exe and the command ".import
>import.txt sample" works just fine.
Whats wrong with using sqlite3.exe? It's a perfectly valid way to
initialise the database.
>
>Is there something comparable that I can do programmatically using SQL
>syntax in my program?
>
>(I've tried various combinations of "insert into sample as select from
>'import.txt'" with no success)
Browse the source of sqlite3.exe, and copy the .import command from there
if you're not happy using sqlite3.exe as is.
Christian
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
