Helo,

Connect to an oracle database:
DNS-less connection
adoconnection.ConnectionString = "uid=;pwd=;server=;" _
& "driver={Microsoft ODBC for Oracle};"

Open a SQL Table:
adoRecordset.Open "Select * FROM tablename", adoconnection

For more information you can always look in the help files under "Connection Object (ADO)" in the msdn library.

HTH,

Preeti