Solved

MS Access through Oracle 9ias

Posted on 2001-07-08
5
164 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
eclipse argument 14 60
ForLoop Example 3 48
javap not working 8 44
JAVA API design with micro service cloud in mind 1 13
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…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
The viewer will learn how to implement Singleton Design Pattern in Java.

774 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