From the link that I provided for the connection strings, and your recorded macro, this connection string might work.

Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;
Password=myPassword;

See this thread for an example. http://www.vbaexpress.com/forum/show...sing-Excel-VBA