solve this

[sreedhar]

hello friend

how to connect to oracle using ado connection code.. how to access data from oracle sql tables....

if u'r sending..me this reply within a day..it's great pleasure for me
thank u friend
sreedhar

[preeti]

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