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
