Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

MS Access through Oracle 9ias

Posted on 2001-07-08
5
165 Views
Last Modified: 2010-04-16
I need to access around 20 MS Excel sheets stored in an Windows NT machine thru Oracle 9ias. Are there any tools to do this? What is the best procedure to be followed. I need to access only few specific cells in Excel sheets.
0
Comment
Question by:pvprabhakar
5 Comments
 
LVL 6

Expert Comment

by:jpk041897
ID: 6263881
Define the cells you want to access as an Excell database.
You could then use Suns odbc bridge driver and Microsofts ODBC driver for Excell to access the data in your spread sheets.

If the 9iAS is on a diffrent LAN than the Excell sheets, you would need a proxy driver such as rmijdbc.

Once the cells are defined as a DB and the drivers are configured, you will be able to read the sheets as if they were tables in a DB. (The DB would be the directory where the sheets are stored).
0
 

Author Comment

by:pvprabhakar
ID: 6264192
Hi
 My oracle server 9ias is on Unix. How would I connect to Excel sheet from Unix Environment? How do I define particular cells in Odbc conection?
0
 

Accepted Solution

by:
ptjii earned 100 total points
ID: 6269236
If you have MS SQL Server 7
this can be done.
You define the Excel Sheet as
linked server in MS SQL Server 7.
Then you can access MS SQL Server 7
using jdbc driver from i-net Opta,
Merant or Web Logic.
0
 
LVL 6

Expert Comment

by:jpk041897
ID: 6271817
Another option option would be to download the rmiJDBC driver at:

http://www.objectweb.org/RmiJdbc/


This driver is pure RMI on the client side and ODBC on the server side.

You place the client on your UNIX box and the Server side on the PC that contains the Excel sheets.

As for defining cells, The ODBC driver only configueres to a path level. The individual files in a given file (as far as Access and Excel go) are defined as tables.

What you do from Java is make a SELECT * from TABLE record set (where TABLE woul be the name of an Excell sheet and the DB column names would be the Excell sheet column names assigned when defining them as a DB).
0
 

Expert Comment

by:SpideyMod
ID: 8289533
Force Accepted

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
HTTPSessionBindingListernter not configured in deployment descriptor 2 65
jsp login check 12 42
swing controls 2 16
Cisco ASA: Java web start no go, asdm launcher no go 3 34
An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
The viewer will learn how to implement Singleton Design Pattern in Java.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question