Find Jobs
Hire Freelancers

Simple excel VBA code to write data to SQL

$30-250 AUD

Đã đóng
Đã đăng vào gần 5 năm trước

$30-250 AUD

Thanh toán khi bàn giao
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.
Mã dự án: 20454164

Về dự án

34 đề xuất
Dự án từ xa
Hoạt động 5 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
34 freelancer chào giá trung bình $128 AUD cho công việc này
Avatar người dùng
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 trong 5 ngày
4,9 (637 nhận xét)
8,6
8,6
Avatar người dùng
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 trong 3 ngày
5,0 (392 nhận xét)
8,1
8,1
Avatar người dùng
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 trong 2 ngày
5,0 (345 nhận xét)
7,3
7,3
Avatar người dùng
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 trong 7 ngày
4,9 (180 nhận xét)
6,9
6,9
Avatar người dùng
i am ready to give you by 3 hrs delivery time only. your requirement sorted out and template already prepared.
$111 AUD trong 1 ngày
4,9 (62 nhận xét)
6,3
6,3
Avatar người dùng
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 trong 2 ngày
5,0 (44 nhận xét)
5,1
5,1
Avatar người dùng
I have many experiences in Excel, SQL. I can show you my projects via chatting. I can complete your project successfully. Thanks.
$140 AUD trong 7 ngày
4,9 (42 nhận xét)
5,4
5,4
Avatar người dùng
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 trong 7 ngày
5,0 (27 nhận xét)
4,8
4,8
Avatar người dùng
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 trong 5 ngày
5,0 (19 nhận xét)
5,0
5,0
Avatar người dùng
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 trong 1 ngày
4,5 (23 nhận xét)
5,0
5,0
Avatar người dùng
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 trong 3 ngày
5,0 (48 nhận xét)
4,6
4,6
Avatar người dùng
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 trong 7 ngày
4,9 (9 nhận xét)
4,2
4,2
Avatar người dùng
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 trong 7 ngày
5,0 (26 nhận xét)
3,6
3,6
Avatar người dùng
I have 6 years experience in VBA coding. I have already implemented similar case and I have the code with me
$88 AUD trong 1 ngày
5,0 (4 nhận xét)
3,1
3,1
Avatar người dùng
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 trong 7 ngày
3,7 (12 nhận xét)
4,0
4,0
Avatar người dùng
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 trong 7 ngày
5,0 (2 nhận xét)
2,7
2,7
Avatar người dùng
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 trong 1 ngày
5,0 (2 nhận xét)
2,2
2,2
Avatar người dùng
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 trong 3 ngày
5,0 (2 nhận xét)
1,8
1,8
Avatar người dùng
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 trong 5 ngày
5,0 (1 nhận xét)
1,1
1,1
Avatar người dùng
I will do this work please contact me
$155 AUD trong 3 ngày
0,0 (0 nhận xét)
0,0
0,0

Về khách hàng

Cờ của AUSTRALIA
Merrylands, Australia
0,0
0
Thành viên từ thg 7 23, 2019

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.