Excel VBA SQL (Azure) Database Work

  • Status Completed
  • Budget $750 - $1500 USD
  • Total Bids 16

Project Description

This project will require that an MS SQL database connection be made through VBA to INSERT, SELECT and UPDATE data from a SQL Azure Database. We currently have an Excel 2007/2010 Workbook which is used to calculate monthly payments for car dealers. The goal of this project is to provide our users the ability to save and then retrieve quotes they have done previously. Most of what we will be doing will be fairly straight forward; INSERT, SELECT, UPDATE (no DELETE for now), however there will be a few trickier pieces which we will need to deal with.

You will be responsible for the database design (please following my naming conventions and data type suggestions as closely as possible) based on the attached DatabaseSpec.xlsx. I am not a SQL programmer however I do have some experience with it, hence why I've made some suggestions around what I want to see done.

You will also be responsible to write all of the required VBA in order to make the required database connection and then the subsequent moving of information back and forth from the workbook to the database.

WHAT I AM LOOKING FOR: I want someone who is experienced in with SQL as well as VBA. You probably don't need to have done much, if any, work with SQL Azure as this is simply a cloud based SQL 2012 database offering. I want someone who can dedicate a fair bit of time to this over the next couple weeks so that we can hopefully have this project complete within 30 days. It is important that you have excellent communication skills. Please speak specifically to this project in your bid, do not reference a bunch of websites you've built, etc. Tell me why you will be the best candidate for this project.

Finally - I was a business analyst for a large software development company for 10 years - I am very experienced working with specification documents and communicating back and forth with developers. I can assure you that I will test the work you do for me quickly and will provide you detailed feedback to any issues I encounter.

Please read the attached [url removed, login to view] and [url removed, login to view] for more details on what the project entails. I will send the winning bidder the workbook which we will be getting and storing the values in. Please let me know if you have any questions.

Get free quotes for a project like this
Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online