Improve company productivity with a Business Account.Sign Up

x
?
Solved

MS Access through Oracle 9ias

Posted on 2001-07-08
5
Medium Priority
?
172 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 200 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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

For beginner Java programmers or at least those new to the Eclipse IDE, the following tutorial will show some (four) ways in which you can import your Java projects to your Eclipse workbench. Introduction While learning Java can be done with…
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 will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

589 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