Query Oracle DB using MS Excel

**mrame** · 06-29-2009, 04:52 AM

Hi All,

I need to retreive data from an Oracle DB from MS Excel 2003. That DB is present in a remote location, say in IP 123.212.122.33, with username "ppppsdf" and password "asdf" and DB name "NE".

My questions are:
1. how should i connect the DB?
2. after connection how should I establish a query?

-thanks

**JONvdHeyden** · 06-29-2009, 05:40 AM

You should probably be using ADO although I'm not sure what the correct connection string would be.

There's an article here that shows to how return data from a database, although again it is not tailored to Oracle DB's. http://www.xtremevbtalk.com/showthread.php?t=217783

It does however demonstrate how to pass a simple plain text SQL string and then return the recordset to a range in an Excel workbook using ADO.

Good luck!