I've been plodding along making some progress with sqlite3.lib in my C++ program.
Right now I'm trying to import a large text file with no success. I understand that the "Copy" command is no longer available in sqlite3. 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. 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) TIA, -Marc
