aspose file tools*
The moose likes JDBC and the fly likes Java with Excel 2007 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Java with Excel 2007" Watch "Java with Excel 2007" New topic
Author

Java with Excel 2007

shadab akhtar
Greenhorn

Joined: Aug 07, 2010
Posts: 1
Hi,
I need to make a swing database aplication with excel 2007 as database. The Application needs to perform basic CRUD operations. Please let me know which api and jdbc driver is to be needed to handle Excel 2007. i am using netbeans IDE
thank you
Lester Burnham
Rancher

Joined: Oct 14, 2008
Posts: 1337
Well, Excel is a spreadsheet, not a database, and you will save yourself much grief by not assuming that it is a DB. Consequently, you'll be better off using a library such as Apache POI to handle Excel files rather than using JDBC.
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 10266
    
168

Also are you sure that you meant Microsoft Excel and not Microsof t Access

[My Blog] [JavaRanch Journal]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Java with Excel 2007