In VB with an ODBC connection to an Interbase database it is possible to move data from Interbase to Access with a SQL construction like this:
INSERT INTO ACCESSTABLE (SUBJECT_TYPE, READ_CODE, TERM30, TERM60) SELECT IB.SUBJECT_TYPE, IB.READ_CODE, IB.TERM30, IB.TERM60 FROM IBTABLE IB IN [ODBC; DB=localhost:C:\TEST\test.gdb; DSN=System 6000; UID=UN; PWD=PW;] Have tried to do the same with SQLite, so instead of Access have SQLite. Tried all sorts of constructions, but sofar no success yet. Problem is always to make it accept a query as above. Would anybody know if this is possible with SQLite? RBS ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------