Oracle Database to Excel Sheet tool development

• Project ID:

  634717

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

Oracle Database to Excel Sheet tool development

Here are the key requirements:

Plug-in to fetch data from Oracle database to Excel Sheet.

1. Establish ODBC connection between Excel and Oracle Database
2. Connection details (TNSName, database id/ password) should be stored at some place in personal computer and not to be asked every time user wants to fetch data.
3. In the plug-in, we shlould be able to provide source of query (could be specific cell, or comment on a cell or inside the Macro) and destination (cell, where fetched data will be published)
4. SQL Query:
1. Query should be capable to accept variables (references) in WHERE clause. These variables may be cell number or cell name which stores the values to be passed.
2. The cell reference to the query could be fixed or may be dynamic reference which is decided in the runtime. (example: the cell on which you execute the macro, should be referred in the WHERE condition in the query)
3. We should be able to run query to fetch data in user-form LOV or dropdowns.


User-Form

1. Enhance the look and functionality of existing user-form

Enhancements

1. Develop capability of right-clicking on a cell and pick the macro to be executed.

More details will be posted. Please feel free to ask questions.

Skills required:

Excel, Oracle, Perl