Solved

MS Access through Oracle 9ias

Posted on 2001-07-08
5
167 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
[X]
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
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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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
ejb on wildfly 5 65
passing enum to a method 4 52
Java regex 5 22
replace an existing file in Dropbox 1 10
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…
Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
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:
Suggested Courses

710 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