You can write your sql commands in a txt file (say mycmd.txt), and then sqlite3 your.databasefile < mycmd.txt
Or I have a simple API that lets you import / export csv (not necessarly CSV inderd, any kind of delimited file) files into SQLite, so you can do it via your own C/C++ application as well. https://github.com/fnoyanisi/sqlite3_capi_extensions On 26/07/2013, at 5:55 PM, "Rob Slater" <[email protected]> wrote: > I have an iPad app that uses several (4) different SQLITE databases and I > currently build these databases using Mozilla Firefox SQLite Manager utility > (on a Mac). The databases are simple (single table) with a number of rows, > and are created from a text file with tab delimited fields. > > This all works but is clunky. I would prefer to create the SQLITE databases > on my Windows PC (where the text files are created). > > My question is whether the SQLITE can do this job and how I go about it. I > suspect that I should be able to set up a file of SQL commands to build the > new database(s), to automate the process somewhat.... > > Any help much appreciated. > > Rob Slater > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
