I was wondering if anyone could help me with the following... It would be easier if I could show some screen shots but here goes.
I was trying to follow the following instructions http://blog.mclaughlinsoftware.com/microsoft-excel/how-to-query-oracle-from-excel-2007/
I get to step 4. and I don't have 'Oracle Provider for OLE DB' so it sends me to the following option http://blog.mclaughlinsoftware.com/2011/11/13/excel-oracle-odbc-driver/
Now I've added OracleODBC_dataSource to Data Sources (ODBC) (but not sure how that helps) - I followed these instructions here http://blog.mclaughlinsoftware.com/microsoft-excel/accessing-to-mysql/ but used it for Oracle instead of MySQL etc.
But when I go back to original instructions and open 'data link providers' I still don't have 'Oracle Provider for OLE DB'? Has anyone had a similar experience and over come it?