Excel VBA SQL (Azure) Database Work

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.

Beceriler: SQL, Uygulamalar için Visual Basic

Daha fazlasını görün: vba excel azure sql, vba azure sql, excel vba read azure database, excel vba sql update, vba azure sql database, update sql azure excel, update azure sql excel vba, working vba database, excel vba azure, why do you want to work for this company, why do you want to work for our company, what is a database programmer, what do database developers do, websites for software developers, visual communication design, vba excel programmer, vba developers, sql programmer software, sql database programmer, sql database business, software developers looking for work, skills of a business analyst, programmer excel vba, need of excel programmer, my sql developers

İşveren Hakkında:
( 81 değerlendirme ) Lethbridge, Canada

Proje NO: #4458421



Hello, I can Complete You with this task. See PM for details. Regards, Giorgi

21 gün içinde 999$ USD
(2 Değerlendirme)

16 freelancers are bidding on average $1378 for this job


I can tell from the Specification you are not a novice, do not see scopes that show decimal(18,4) and decimal(6,4). I see you have FK(Foreign Key) on some of the fields but you do not say what it is linked to. For in Daha fazlası

in 30 gün içinde1100$ USD
(32 Değerlendirme)

Hi, Please check pmb.

in 30 gün içinde1485$ USD
(3 Değerlendirme)

I have a very strong experience (more than 15 years) in VBA and SQL Server and this project combines them both.

in 30 gün içinde1320$ USD
(2 Değerlendirme)

Hi We are Expert in VBA and Datbase Transfer /connection Please see PMB

in 25 gün içinde1287$ USD
(2 Değerlendirme)

Hi There!! We reviewed the document, please find our understanding and questions in PMB. - Thanks

in 15 gün içinde1056$ USD
(1 Değerlendirme)

Dear Buyer, We are highly interested on your project. We read and understand your requirements as we have experienced mobile app on iPhone , Android , windows mobile , bb , web development as well as desktop dev Daha fazlası

in 7 gün içinde1078$ USD
(0 Değerlendirme)

Hi, I've read your scope and the attached doc and excel file. I wont bombard you with details of work we've done in the past, but will surely inform you of an api we develop for box.com. Also for a client from Canada. Daha fazlası

in 40 gün içinde2750$ USD
(0 Değerlendirme)

VBA developer (with a heavy Insto trading and finance background with major banks and fund managers). I build professional solutions. Period. My pedigree in your PM. SteveP.

in 21 gün içinde1648$ USD
(0 Değerlendirme)

Experts [url removed, login to view] to start immediately.

in 35 gün içinde2200$ USD
(0 Değerlendirme)

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te Daha fazlası

in 45 gün içinde1339$ USD
(0 Değerlendirme)

I am an experienced BI architect with considerable design and development experience, specifically around Information Management solutions. I am well-versed in MS SQL and VBA. Please see PM for further details

in 3 gün içinde1100$ USD
(0 Değerlendirme)

Hello.I'm a programmer in vba for excel and I use sql with [url removed, login to view] you.

in 30 gün içinde935$ USD
(0 Değerlendirme)

Please check PMB.

in 30 gün içinde1100$ USD
(0 Değerlendirme)

20+ Yrs. of experience developing IT Solutions using Microsoft Technologies. Expert in Excel-VBA and MS SQL 2000 to 2012. Created similar solution before a month.

in 30 gün içinde1595$ USD
(0 Değerlendirme)

Dear Sir, My name is D and I am a individual database developer and would like to offer my services. Have a nice day and best regards! D

in 10 gün içinde1056$ USD
(0 Değerlendirme)