MSFT JET supports heterogeneous data sources. Assuming you have a JET MDB with a data-connection to Oracle and another data-connection to SQLite, and have attached the relevant tables from each, you could move data from one back-end data source to the other. This approach brings the data from the first back-end out to the client, which then pushes the data out to the other back-end.
http://my.safaribooksonline.com/0596004397/adonetckbk-CHP-3-SECT-6#X2ludGVybmFsX0ZsYXNoUmVhZGVyP3htbGlkPTAtNTk2LTAwNDM5LTcvMTM2 Regards Tim Romano On Thu, Jun 3, 2010 at 11:25 AM, Simon Hax <wdl...@web.de> wrote: > Is something possible like > > insert into sqlite_table.ColumnA select x from ta...@oracledb > > ? > (Without copying into local memory (firstly do a select from Oracle ) > and then insert into a Sqlite database (via e.g. ADO ). ) > > S. > ___________________________________________________________ > GRATIS für alle WEB.DE Nutzer: Die maxdome Movie-FLAT! > Jetzt freischalten unter http://movieflat.web.de > > _______________________________________________ > 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 > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users