Home » RDBMS Server » Server Administration » Accessing data in Excel from Oracle
Accessing data in Excel from Oracle [message #55674] Fri, 07 February 2003 04:18 Go to next message
nitin gupta
Messages: 4
Registered: February 2002
Junior Member
Hello All,

Our management in a remote city has given us a MS Excel file having a sheet namely 'DATA'. They have asked us to configure ODBC enabling this file to refresh data from their Oracle 8i DB. The machine we are running this XLS file has Oracle 8 Client, successfully accessing data thru' SQL Plus.

Please tell us how to configure this XLS file to the remote database?

Thanks in advance,

Nitin Gupta
Tata Infotech Ltd
Plot 4&5
NOIDA Special Economy Zone
NOIDA-201 305
Tel: 95120-256 7622-24, 256 2356/376/585/588-92 Extn: 825

Report message to a moderator

Re: Accessing data in Excel from Oracle [message #55688 is a reply to message #55674] Sat, 08 February 2003 00:18 Go to previous messageGo to next message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Hello,
You can do this using ORAEXCELLITE, which u can get it from Kevinloney.com / a free cd that will be shipped with ORACLE 8i DBA handbook

See if that works..

sai

Report message to a moderator

Re: Accessing data in Excel from Oracle [message #55694 is a reply to message #55674] Mon, 10 February 2003 09:20 Go to previous message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
There are a bunch of products but I have NO idea on what is good.

Googleit with 'Oracle Excel'.

http://www.oraxcel.com/
http://www.dataeasier.com/

Report message to a moderator

Previous Topic: Farsi language in Oracle9i
Next Topic: Database Size ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 07:29:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.