I don't know what JET is. I testet ADO. That works. But it'is slow and you have to write some (to much) code.
Much more better would be a solution like a direct LINK (like an Oracle Database Link). as shown in my first email: insert into sqlitetable_columA select ColX from ta...@oracledb If you have 2 OracleDBs you can define a LINK from one OracleDB to the other, which allows you then to do insert into my_oracle_table_columnA select X from ta...@remoteoracledb where remoteOracleDB has to be defined earlier as an Oracle Database Link Really easy to do with Oracle. S. ____________ 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. ___________________________________________________________ NEU: WEB.DE DSL für 19,99 EUR/mtl. und ohne Mindest-Laufzeit! http://produkte.web.de/go/02/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users