Find Jobs
Hire Freelancers

Simple excel VBA code to write data to SQL

$30-250 AUD

Closed
Posted over 4 years ago

$30-250 AUD

Paid on delivery
Excel spreadsheet with rows of data that need to update to an existing SQL database when the data in the spreadsheet changes. Just require the generic VBA code to do this. Already updating the spreadsheet from SQL. Need to push data from excel to SQL.
Project ID: 20454164

About the project

35 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
35 freelancers are bidding on average $129 AUD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$220 AUD in 5 days
4.9 (398 reviews)
8.1
8.1
User Avatar
Hello, I can write your VBA to update SQL database, I already done this many times before as I work with SQL - Excel/Access integration allot so I can complete it in a day so feel free to contact me if you would like to share the files and would like me to work on this project. Cheers!
$140 AUD in 2 days
5.0 (36 reviews)
7.5
7.5
User Avatar
Hello, As an expert in SQL and experienced VBA developer, i am very much interested to do this project. Looking forward to have a positive response from you. Thanks
$130 AUD in 3 days
5.0 (337 reviews)
7.7
7.7
User Avatar
Hello, I am an independent, experienced excel expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.
$180 AUD in 7 days
5.0 (159 reviews)
6.7
6.7
User Avatar
Hi. Great app writer for your projects. I have writen database, excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
$50 AUD in 2 days
4.9 (55 reviews)
5.4
5.4
User Avatar
Hello, I am ready to discuss project with you. Being experienced in working on several excel projects related to macro/formula/vba/functions/charts etc. Based on that i can quickly help you in getting your project done as you mentioned in the description. I am available to start now and want to discuss more specific details. Looking forward to have further project discussion on chat. Thanks. Sapna Dalsaniya
$70 AUD in 2 days
5.0 (44 reviews)
5.1
5.1
User Avatar
I have many experiences in Excel, SQL. I can show you my projects via chatting. I can complete your project successfully. Thanks.
$140 AUD in 7 days
4.9 (42 reviews)
5.4
5.4
User Avatar
The best way to use SSIS ETL tool which will read your excel data from any specified excel path and update your sql database table. You can schedule this ETL tool from sql job OR you can manually execute your package. Let me know if you want to discuss further. I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database/Datawarehouse - SQL Server, Oracle, MySQL -- Proficiency (P4) BI - Microsoft MSBI and Informatica ETL -- Proficiency (P4) Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... -- Proficiency (P3) Cloud - Azure (Paas and IaaS) -- -- Proficiency (P1) My Technical background • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
$180 AUD in 7 days
5.0 (24 reviews)
4.8
4.8
User Avatar
i am ready to give you by 3 hrs delivery time only. your requirement sorted out and template already prepared.
$111 AUD in 1 day
4.9 (20 reviews)
5.1
5.1
User Avatar
Hi, sir I have best skills and much experiences in c/c++, c#, python, nodejs, php, javascript, unity development. I have already completed so much projects and get good reviews from employers. I am sure I can complete this project. If we have a chat, then we can make sure for each other. If you award this project to me, then you will get great result! Let's work for this project. Thanks
$140 AUD in 7 days
4.9 (9 reviews)
4.1
4.1
User Avatar
Hello, I've read your project requirements thoroughly. It's quite an easy task. I have vast experience in both VBA and SQL. I can create an event that will be triggered whenever there is a change in the Excel file. If interested, we can discuss this further on chat.
$55 AUD in 1 day
4.7 (17 reviews)
4.4
4.4
User Avatar
Hello, I can help you with this project, but I have some questions like how many tables and columns needs to be updated. I will start working immediately if you send me the information and if its possible DB connections.
$55 AUD in 3 days
5.0 (33 reviews)
4.2
4.2
User Avatar
Professional software developer, Ready to develop the required functions and procedures code to move data between me access database and SQL server database Regards,
$250 AUD in 5 days
5.0 (2 reviews)
3.8
3.8
User Avatar
Hello - I can build the Excel VBA code that will keep track of all the changed cells and then on clicking a button, generate SQL for all the changed values. I'll need to know a few more details, such as whether you anticipate the key columns to change as well. Please feel free to message if you would like to discuss anything. Regards
$140 AUD in 7 days
5.0 (26 reviews)
3.6
3.6
User Avatar
I have 6 years experience in VBA coding. I have already implemented similar case and I have the code with me
$88 AUD in 1 day
5.0 (4 reviews)
3.0
3.0
User Avatar
I can give you the VBA code to do this very quickly. You will need to add a reference to Microsoft ADO in the VBE, although if you are already importing data from SQL queries I assume that you already have this reference. Please send name and field names of the SQL table that you wish the data to be imported into from Excel
$140 AUD in 7 days
5.0 (2 reviews)
2.7
2.7
User Avatar
Hi Greetings of the Day, I am interested in this task, I am full time freelancer carrying 15 yrs of experience in Web and Windows development and Mobile development using ASP.Net, C#, SQL server, Xamarin, WebAPI, XML, Cr Reports etc. I have 3 years experience in remote working for US clients. Please feel free to contact me. Thanks
$200 AUD in 7 days
4.3 (7 reviews)
3.1
3.1
User Avatar
I can do this for you. I've written many VBA applications (and other in languages) that have two way communication with SQL. I have 15+ years automating MS office products, with an emphasis with Excel. I can write you some easy-to-use functions for Excel front and/or just generic VBA code you can modify to your needs which I can explain how to do. Please contact me and let's talk about it. If it is as simple as it sounds I can come down on the price quite a bit. Thanks, Ryan
$140 AUD in 1 day
5.0 (2 reviews)
2.2
2.2
User Avatar
Hi, I am a engineer and I work as a business analyst. I have experience in project with excel vba and sql. I would be very happy to work on this project. Thanks a lot Alessio
$61 AUD in 3 days
5.0 (2 reviews)
1.8
1.8
User Avatar
hi I am an expert in excel with 6 years of experience in excel VBA and google spreadsheet. I have many records for quick and accurate data processing. You can send more information I will create a template for you.
$130 AUD in 5 days
5.0 (1 review)
1.1
1.1

About the client

Flag of AUSTRALIA
Merrylands, Australia
0.0
0
Member since Jul 23, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.