My company's application has a need to regularly refresh an entire
read-only database, at one week intervals.
The COPY API call is no longer available. I have read the documentation on
the .IMPORT command but it is a line item command interface.
I need a way to programmatically import data from flat files so that we
can automate this process. We would prefer not to create batch processes
to do this using the SQLite command line interface, although after
experimentation, I don't see that this will work (e.g. - " > sqlite3
.import Categories.txt " fails).
Just in case I have missed something in the SQLite documentation, I'll ask
this question:
"Is there a SQLite API call that will facilitate data importation from TAB
character delimited flat files?"
If not, I will write the software to do it.
Thanks,
Lee Crain
