What you could use is an open source ETL that has connectors with Sqlite. Talend Open Studio is an open source ETL tool for data integration and migration experts. It's easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component. It allows the user to get a graphical and functional view of integration processes.
For more information: http://www.talend.com/ Robert Citek-2 wrote: > > On occasion I have had a need to import large amounts of data from > standard input via a pipe. Here's an example of how to import from a > pipe using sqlite3 on Ubuntu: > > $ { grep -v '^#' <<eof > # create the table > create table foo (bar int) ; > eof > } | sqlite3 foo.sqlite > > $ seq 1 1000000 | sqlite3 foo.sqlite '.imp "/dev/stdin" "foo"' > > $ sqlite3 foo.sqlite 'select count(*) from foo; ' > 1000000 > > Regards, > - Robert > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/importing-data-to-sqlite-from-stdin-tp24256696p24256851.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
