File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes excel as a database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "excel as a database" Watch "excel as a database" New topic

excel as a database

victor shon

Joined: Dec 18, 2007
Posts: 1
i am developing a java app, where i need to use Excel as the database. the difficulty that i facing is that,the Excel is stored in another computer on the same network.The Excel is in "Shared" mode. cud you pls help me with suitable steps and also if possible give me a some basic code to solve this
thank you

[edited to use a meaningful subject line - was "Victor"]
[ December 23, 2007: Message edited by: Jeanne Boyarsky ]
Walter Bernstein
Ranch Hand

Joined: Dec 19, 2007
Posts: 57
Check POI for Excel access:
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42965
I'm sure you're aware that there are better methods of storing data than Excel, e.g. relational databases. Can you question the requirement of misusing Excel as a database?
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33106

Welcome to JavaRanch!

Is that "other computer" a server or someone else's PC? If the later, do you have a requirement for what should happen when the other computer is unavailable.

If the Excel file is in CSV, you can just use Java parsing. If it is a true Excel file, POI is good for reading. I agree with Ulf that Excel isn't a database and you should avoid using it as such.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Hendy Setyo Mulyo
Ranch Hand

Joined: Dec 01, 2004
Posts: 219

There are other options than using Jakarta POI.
You may also have a look at Andy Khan's Java Excel API or Nilostep xlsql Excel JDBC Driver.
Use Google with keywords 'excel jdbc ' or 'java excel'

Hendy Setyo Mulyo
SCJP 1.4 (95%), SCWCD 1.4 (94%)
I agree. Here's the link:
subject: excel as a database
jQuery in Action, 3rd edition