SQL & PL/SQL

Hello!

Probably this has been answered before, and I don't mean to be repetitive, but I'm trying to insert the results from a query I generate in Oracle into an Access DB and I cannot manage to do it. I am using a version 9.2.0.8 of Oracle, into a 2003 Access, and my query looks like:

INSERT INTO `C:\Documents and Settings\Fpinilla\Desktop\Virginia\TOAD_experiments4db\DQRS_metrics`.`McCracken data` (`Metric_ID`, `MyDate`, `Error Number` ,`Total Balance`)

SELECT '208' AS Metric_ID, '31/3/2011' AS MyDate, COUNT (MC_MASTER.LOAN_NUMBER) AS Error_Number, SUM (MC_INVESTOR.CURRENT_PRIN_BAL) AS Total_Balance

FROM ((CRE.MC_MASTER MC_MASTER
LEFT OUTER JOIN CRE.MC_PROPERTY MC_PROPERTY
ON (MC_MASTER.PROCESS_DATE = MC_PROPERTY.PROCESS_DATE)
AND (MC_MASTER.LOAN_NUMBER = MC_PROPERTY.LOAN_NUMBER))
RIGHT OUTER JOIN CRE.MC_CIF MC_CIF
ON (MC_MASTER.LOAN_NUMBER = MC_CIF.LOAN_NUMBER)
AND (MC_MASTER.PROCESS_DATE = MC_CIF.PROCESS_DATE))
LEFT OUTER JOIN CRE.MC_INVESTOR MC_INVESTOR
ON (MC_MASTER.LOAN_NUMBER = MC_INVESTOR.LOAN_NUMBER)
AND (MC_MASTER.PROCESS_DATE = MC_INVESTOR.PROCESS_DATE)
LEFT JOIN (SELECT MC_RRAT.LOAN_NUMBER,
Max(MC_RRAT.REVIEW_DATE) AS MaxOfREVIEW_DATE,
Max(MC_RRAT.BORROWER_DEFAULT_GRAD) AS MaxOfBORROWER_DEFAULT_GRAD,
Max(MC_RRAT.FACILITY_DEFAULT_GRAD) AS MaxOfFACILITY_DEFAULT_GRAD
FROM CRE.MC_RRAT
GROUP BY MC_RRAT.LOAN_NUMBER) MaxRevDateRR
ON MC_MASTER.LOAN_NUMBER = MaxRevDateRR.LOAN_NUMBER

WHERE (MC_MASTER.ACTIVE_STATUS_CODE = 'Y')
AND (MC_MASTER.PROCESS_DATE = trunc(sysdate,'MM')-1)
AND ( (MC_INVESTOR.INVESTOR_NUMBER BETWEEN 100 AND 199)
OR (MC_INVESTOR.INVESTOR_NUMBER BETWEEN 400 AND 499))
AND (MC_INVESTOR.SEQ_NUMBER = 1)
AND (MC_PROPERTY.SEQUENCE_NUMBER = 1)
AND (((TO_DATE ((LPAD(MC_MASTER.MATURITY_DATE,8,'0')), 'mmddyyyy')) IS NULL)
or ((TO_DATE ((LPAD(MC_MASTER.MATURITY_DATE,8,'0')), 'mmddyyyy')) < (trunc(sysdate,'MM')-1)))




Could anyone give me any ideas?
Thanks a lot! :)