Thanks Christian for your response. >>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. Yes, but I'm thinking of using sqlite3 as the tool for generating output reports on the fly. Each report will be dynamically defined by the user. >> >>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. I'm using Borland CBuilder and have not been able to build sqlite3. But your idea has merit. Maybe ".import" uses sql? Thanks, Marc
