Zope Ms Access and Oracle

Hello all.

I'm trying to select some data via a dtml method, from some Oracle tables, and have them inserted into a Ms Access table.
(I'm not allowed to play with the real software)

I'm attempting to do this with a ZSQL select - then an insert, something along these lines...

Form
<form name='form1' action='meth_step_3'>
<tr>
<td>Start Date</td>
<td><input type='text' name='start_date'></input>
<td>End Date <input type='text' name='end_date'></input>
<input type='submit' name='Go'></input></td>
</form>


Oracle Select
select
H.mobile_no as mobile_number,
H.DEALER_NO as dealer_code,
SCD.ENTRY_DATE as date_added
from
jan.sc_detail SCD,
jan.handset H
where
SCD.handset_code = H.code and
SCD.comments = 'SERVICE ADDED' and
SCD.ENTRY_DATE > ('<dtml-var start_date>') and
SCD.ENTRY_DATE < ('<dtml-var end_date>') and
(H.status = 'A' or H.status = 'B') and
(H.DEALER_NO NOT BETWEEN '0000' and '0004')

Dtml method
<!--#with sql -->
<!--#call select_all_connects -->
<!--#call insert_all_connects -->
<!--#/with -->

MS Access Insert

INSERT into mConnectList
(
dealer_code,
mobile_number,
date_added
)
values
( <!--#sqlvar dealer_code type="string" -->,
<!--#sqlvar mobile_number type="string" -->,
<!--#sqlvar date_added type="string" -->
)

I'd love to do it in a single action - select into or the like, but for the fact that a ZSQL method can only connect to one DB at a time.

I'm not sure if there is a way of doing this with a dtml/ZSql method, but I'm hoping.

Thanks.
Julian