Take a look at the apsw (Another Python SQLite Wrapper) shell which has an .autoimport command that may do what you want.
http://apidoc.apsw.googlecode.com/hg/shell.html#commands Code is here: http://code.google.com/p/apsw/ There are probably other tools and libraries that accomplish the same thing in various ways. --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org > -----Original Message----- > From: [email protected] [mailto:sqlite-users- > [email protected]] On Behalf Of Sébastien Roux > Sent: Saturday, 22 September, 2012 13:06 > To: General Discussion of SQLite Database > Subject: [sqlite] dynamic bulk import > > Hi is there way of doing a dynamic file import into sqlite without > specifying the table fields. Just specifying the target (temporary?) table > so columns or fileds are created dynamically. > > If this cannot be done with cmdline interface maybe using perl amodules > (DBD, DBI)? > > Many thanks for any help you could provide. > > Sébastien Roux > _______________________________________________ > 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
