The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I currently have a data connection established with an Oracle database that will output data into several sheets in an Excel document. I need you to build a macro that can be installed on multiple user machines via an Excel Add-in that will allow the users to format this data, edit it, and produce SQL statements based on the edits in a flat .sql file.
Please see two attachments for detailed requirements, as they are better formatted in the attachments.
The basics of the requirements:
Data is pulled from Oracle. I need the creation of a new worksheet in Excel, with dynamic features based on the data pulled from Oracle. The worksheet will need to allow for users to edit it and then save it. From there I have a formula that will generate a SQL script based on the value of a cell. I will need this formula run for each cell so the macro can then produce a SQL script which can be sent to a DBA and executed.
The details are laid out in much more depth in the attachments. Please make sur...
Sign in or Register to see more