|
Re: How To Use Oracle Tables in MS-Excel?? [message #70205 is a reply to message #70203] |
Fri, 03 May 2002 03:14   |
indrajeet.mitra@timesgrou
Messages: 1 Registered: May 2002
|
Junior Member |
|
|
Hi Anil ..
U can import oracle table into MS-Excel(Office-2000). Pl follow
the following steps
1. In Excel .. go to Data/Ger External Data/Create New Database Query.
2. Choose Datasource .. If u dont hv create the new one selecting ODBC driver as Microsoft ODBC for Oracle.
3. Connect the user u want and select the table and the cols. u want. U will get all ur data in Excel.
Best of luck.
cheers
Indrajit
|
|
|
|