RE: Oracle to Excel

[Steve . Parker]

This is how I do it:

1)        Set-up an ODBC data source using either the Oracle or MS ODBC driver.
2)        In Excel, use the Date->Get External Data menu option
3)        Specify the ODBC driver
4)        In the Wizard, select the table columns, where and sort  or Untick the box and use MS Query where you can type
        in your own query using the SQL button
5)        The data is returned into the spreadsheet

Steve Parker
E Mail: [EMAIL PROTECTED]
        ------------------------------