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