Solved

MS Access through Oracle 9ias

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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
hash value 2 39
topping1 challenge 7 53
Modeling a class in java 5 34
Java array passed to SQL where clause 23 43
Java contains several comparison operators (e.g., <, <=, >, >=, ==, !=) that allow you to compare primitive values. However, these operators cannot be used to compare the contents of objects. Interface Comparable is used to allow objects of a cl…
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 …
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:

743 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now