Win a copy of Five Lines of Code this week in the OO, Patterns, UML and Refactoring forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

JSP/Servlet With MS Excel?

 
Ranch Hand
Posts: 200
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I am new to this wonderful group. I am tryind to do one project in JSP/Servlet with MS Excel and MS Access. Before I am going to start this, I thought it will be useful for me to get some advice from this group.
I will just overview my project:
1. MS Access is the database.
2. MS Excel is used in two ways. One It has been used as database. That is the data in excel has to upload to MS Access. And the datas in the MS Access to be transferred to MS Excel(to generate the report)
Done all the other manipulation, calculation, updation and everything in JSP and Servlet and it has to be stored in MS Access.

I want to know what are all things I have to know to use JSP/Servlet with MS Excel. I have used Visual Basic 6.0 with Excel. I don't know how to use in Java(JSP/Servlet).

For example:
A user has to fill up the JSP form and it has to stored in MS Access. (No problem with this).
I want to list all the data in the MS-ACCESS to MS-Excel.

Any sample Open-source will available or any directions/suggestions will be helpful

Thanks,
Mark.
 
Ranch Hand
Posts: 456
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Mark,

that sounds a bit like a very rough sketch to me. it seems that you want to put a web-frontend in front of a database. i did'nt get the role of excel in you constellation.

but, as a fist shot: you'll need to develop some sort of interfaces between the different layers of your application. if a table in in excel gets changed, some sort of native (=VB) code will have to jump in to process the data to be readable by another (=JSP) application. honestly, i don't know how to access a access-DB from a java application (jsp/servlet). i'm sure it's possible. forum search / google will help you :-)

maybe you should break down your problem in some smaller steps:
- develop a jsp front-end with non db-functionality
- connect it to a db (with jdbc)
- connect it to ms-access
- bring excel into the game

overall, your application is not trivial at all. maybe start with something smaller to get a better idea and understanding of java.

best regards,
jan
 
And then the flying monkeys attacked. My only defense was this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic