Home » RDBMS Server » Server Utilities » How To Use Oracle Tables in MS-Excel??
How To Use Oracle Tables in MS-Excel?? [message #70203] Fri, 03 May 2002 00:13 Go to next message
Anil
Messages: 80
Registered: September 2001
Member
Hi,

I want to use Oracle Tables in MS-Excel, what are the steps to do so. Please can you make them in points for me??

Thanx,
Anil.
Re: How To Use Oracle Tables in MS-Excel?? [message #70205 is a reply to message #70203] Fri, 03 May 2002 03:14 Go to previous messageGo to next message
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
Re: How To Use Oracle Tables in MS-Excel?? [message #70716 is a reply to message #70203] Wed, 17 July 2002 04:43 Go to previous message
arunjhalani
Messages: 1
Registered: July 2002
Junior Member
Sir That is Ok
But I ve typical Problem
In MS QUERY Mode the data retrieves too fast (Approx 50,000 recorde take 50-60 Secs wherea as When I sent this data to Excell Pivot Report it takes 40-45 mins
Previous Topic: How to add more information into an exported file?
Next Topic: IMP-00010: not a valid export file, header failed verification
Goto Forum:
  


Current Time: Mon Dec 23 07:11:03 CST 2024