That makes good sense - if my task were repetitive I would take that route - I opted to write a quick and dirty PHP script just to handle this one-off case and it worked like a charm.
I can share the script as a jumping off point for anyone who is interested. *Ben Marchbanks* John Stanton wrote: > Write a simple program.. > > As I recall our programs which do this use the Expat parser and obey a > protocol where the XML DTD represents the database tables and columns so that > SQL can be generated directly from the XML. It makes for a handy way to > transport a database, or a part of a database in a universal format. All > that is needed is the program to scan the database and generate XML and one > to receive the XML and transform it into SQL statements. > > > Ben Marchbanks wrote: > >> Whats the best way to import a large number of records ? >> 120K+ currently stored as an XML file. >> >> >> > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users