View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] richmarin@earthlink.net is offline
external usenet poster
 
Posts: 13
Default Newbie : Oracle to Excel Part 2. RDO or ADO?


I am using Excel 2002.

Thanks for the previous reply. I wanted to do the following. I wanted
to pass an SQL statement to Oracle. For example, here is a pretend SQL
statement

Select customer id, name from customer table where state = "NY"

Then use RDO or ADO to get the data, and place it into Excel.

How should I do this. Do I still create an ODBC link? Can I still pass
SQL statements using ODBC?

Thanking you all in advance

Rich

...