Google Answers Logo
View Question
 
Q: Looking for web application for 2-way data exchange between Database and Excel ( No Answer,   0 Comments )
Question  
Subject: Looking for web application for 2-way data exchange between Database and Excel
Category: Computers > Software
Asked by: jgolfer-ga
List Price: $10.00
Posted: 02 Aug 2004 09:54 PDT
Expires: 01 Sep 2004 09:54 PDT
Question ID: 382454
I am looking for a web-based application, must be a JSP/Servlet
solution, which can be deployed to an Intranet environment for 2-way
data exchange between Oracle databases and Excel. By 2-way data
exchange I mean user would be able to login to the application, browse
the databases entities and download selected data into Excel
spreadsheet. User would then be able to make changes in Excel and
upload the data back into the database to update the data. Both
download and upload need to be performed through web browser.

The application also needs to provide a web-base administrative
console that allows admin user to:

1. Specify the databases, tables and columns that will be exposed to
the end users for download and/or upload
2. Create user accounts and assign security roles to the user
accounts. The security roles determine whether a user has the download
and/or upload privileges to certain databases, tables and columns.
3. Customize SQL statements used for querying the data when generating Excel file.
4. Customize generated Excel file format, including column titles and
cell color, locking cells.

The application can be deployed on Tomcat, WebLogic or Websphere
running on Linux or Windows XP Server.
Answer  
There is no answer at this time.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy