Since you have no control on the JET/ACE engine query plan and since Oracle must do all the calculation before sending data back bypass MS Access query planning by using a Pass-Thru OBDC query which will use native Oracle SQL.

The append query in MS Access will reference your new Pass-Thru query. The SQL of the APPEND query will be something like: INSERT INTO localtable SELECT * FROM passthruquery;