Remote Network And System Administration Job In IT And Networking

EXCEL VBA SQL DATA WORK

Find more Network And System Administration remote jobs posted recently Worldwide

Hi,
I am looking for someone to build me a custom spreadsheet.
Should have a small section for:
Server Name:
ID & Password(should hide password) and checkbox to connect with Windows Credentials.
Drop down for what database on the server named above it should run query
Query Box or drop down for stored procedures with From & Two dates and box for extra criteria
Check box Ability to Run Query (Type in ) or Stored Procedure (Drop Down)
1 Text box to run query so If I wanted to type in the above it would work exec procRptMySP.....
2 Stored procedure drop down populate list from selected database From and Two dates extra criteria text box that will append on end of query so I could type 1, -1 in box.
Ability to click a checkbox to run stored procedure on all databases(or select if we make the databases checkable) and join by union since all fields should be the same.
About the recuiter
Member since Sep 9, 2017
Yosef
from Hazafon, Israel

Skills & Expertise Required

Excel Excel VBA sql VBA VBScript 

Candidate shortlisted and hiredHiring open till - Apr 20, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$239.52

Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Similar Projects

Quick Excel/VBA fixes

Have a file with a few short pieces of code/formulas - need a few quick fixes. I will provide everything that you want through Toogit chat.

Extract data from the web into Excel

extract data from the web into Excel the web include exhibitor list with company name, email, website, contact person email, contact number.
need to use web scrape tools extract these data to excel and delete the duplicated pieces of information.

Need mentoring for SQL Database Servers, and WordPress web development.

I am working to adapt an existing SQL server and Wordpress page to work for a similar application. I would like to learn the basics of working with the server and webpage to eliminate problems with simple solutions.

I am a recent college gra...read more

Quickbooks help needed

I need help with QuickBooks for very small business with less than 20 transactions per month. Need help to correct errors. Help could be remote via Team Viewer and telephone.

I need a SQL query written for my database and a way to view and segment data.

Im looking for a programmer that can write a SQL query based on the data we need and then import it to Access database so we use the data.