Why not just read it from the Oracle database and use VBA to dump the data
into Excel. Far simpler.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DevInstinct" wrote in message
ups.com...
Unfortunately, I tried it before and it's not working.

I tried:
INSERT INTO [Sheet99$] SELECT * FROM [Provider=OraOLEDB.Oracle;Data
Source=THIS.THAT;User Id=SOMETHING;Password=SOMETHING].THE_TABLE

and

INSERT INTO [Sheet99$] SELECT * FROM
[odbc;Provider=OraOLEDB.Oracle;Data Source=THIS.THAT;User
Id=SOMETHING;Password=SOMETHING].THE_TABLE

There either something in the FROM clause that I miss or it's just not
supported by the Microsoft Jet engine.

Any further help is welcome.

Thanks,
Martin