Find Jobs
Hire Freelancers

Write VBA code to update a table in worksheet and update SQL table

$10-30 AUD

Ditutup
Dibuat sekitar 5 tahun yang lalu

$10-30 AUD

Dibayar ketika dikirim
A simple job to update a column in a table in a worksheet and to update an existing SQL table. Taks required: 1 - User selects a range and press a button 2- A menu form is displayed asking user to select one of the 7 radio buttons (I have already created this form) 3 - User selects a radio button and clicks on "UPDATE" button 4 - Each radio button has a corresponding listcolumn with date values 5 - Depending on the date in the corrsponding value, a status "ON TIME" or "LATE" is determined 6 - An update query is run to update the databse with status and item number 7 - Gates higher than the selected gates are cleared out in the SQL databse I would like to give a quick demo of the spreadsheet and the SQL database before awarding the project so you are fully aware of the requirementss. After you have seen the demo, you can update your bid and advise the time you will need to finish the task. For a solid prgrammer with VBA and SQL knowledge, it shouldn't take more than three hours to get it done. In your response, please tell me the name of current prime minister of australia. this is so i can filter out people who don't read the project description and just post bids without knowing the scope.
ID Proyek: 18648066

Tentang proyek

25 proposal
Proyek remot
Aktif 5 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
25 freelancer menawar dengan rata-rata $61 AUD untuk pekerjaan ini
Avatar Pengguna
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
$160 AUD dalam 3 hari
5,0 (23 ulasan)
5,8
5,8
Avatar Pengguna
current pm of australia : Scott Morrison Hello, I am ready to discuss project with you. Being experienced in working on several excel/vba/sql projects of various compleities, i can help you in getting your work done quickly and efficiently. I am available to start now and want to discuss more specific details. Looking forward to have further project discussion on chat. Thanks. Vimal Arora
$40 AUD dalam 2 hari
4,9 (74 ulasan)
5,6
5,6
Avatar Pengguna
Scott Morrison... am not a random bidder.. Please ping me if you are interested with my proposal and share more detail.. thank you..
$100 AUD dalam 1 hari
4,9 (17 ulasan)
4,7
4,7
Avatar Pengguna
Scott Morrison You do not mention anything about the SQL database. What database brand is it, where it resides. Will I have write access to the database for testing? MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, database design and SQL, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models. I have a high performance desktop computer with which I can deal with extremely large and complex worksheets.
$140 AUD dalam 2 hari
5,0 (7 ulasan)
4,1
4,1
Avatar Pengguna
Scott Morrison I have excellent command on MS Excel and know how to connect to and update SQL database using VBA. I have completed complex projects in Excel before . For instance - Built a POS and inventory management system - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
$100 AUD dalam 2 hari
5,0 (4 ulasan)
4,1
4,1
Avatar Pengguna
I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” Mohsan
$250 AUD dalam 1 hari
5,0 (4 ulasan)
3,1
3,1
Avatar Pengguna
Australia PM: Scott Morrison (says google) I'm an engineer with advanced working knowledge and experience in Excel and VBA including interaction between different software (Word, excel, powerpoint, access, Autocad etc.), web scraping, Access DB design, management Dashboards, KPI's, and proficient coder in VB.Net, C#, Python, VB6.
$50 AUD dalam 3 hari
5,0 (3 ulasan)
2,4
2,4
Avatar Pengguna
Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance Thanks
$25 AUD dalam 0 hari
5,0 (2 ulasan)
2,0
2,0
Avatar Pengguna
Scott Morrison Hello, Hope you are doing well. I can help you in your project About me & what I can provide - • 5 Yrs. of Experience in EXCEL & VBA. • Knowledge of FORMATTING, PIVOT, SLICER, GRAPHS, CHART & FORMULAS. • Macro coding for USERFORM and other COMPLEX TASKS possible. • HIGH ACCURACY. • Work in TIGHT DEADLINE. • Can start working IMMEDIATELY. Please ping me for more discussion.
$28 AUD dalam 0 hari
4,6 (2 ulasan)
1,8
1,8
Avatar Pengguna
Scott Morrison Hi, This is to express my interest on helping you with your project. I am an experienced programmer with exposure in Visual Basic for Applications. My experience covers all versions of Microsoft Excel. Thanks & Regards, Peter
$100 AUD dalam 3 hari
4,4 (2 ulasan)
2,0
2,0
Avatar Pengguna
Current PM of Australia - Scott Morrison Hi, I am a VBA developer plus have around 10 years of experience working with SQL. I am sure to implement the requirement as I have enough expertise in the fields required to implement this project. Please share the requirement and give a demo of it for more clarification. Please be assured of the high-quality, error-free delivery with quick turnaround. Thanks. Regards Mohd F.
$30 AUD dalam 1 hari
5,0 (2 ulasan)
1,0
1,0
Avatar Pengguna
Scott Morrison Hello, The above is the prime minister of Australia, so can you show me the demo, after seeing the demo I can give you the price and the time line.
$25 AUD dalam 1 hari
5,0 (1 ulasan)
0,8
0,8
Avatar Pengguna
Ex- Mckinsey & Company COlleague. Who works with passion and 100% gurantee for Error free work. Price can be negotiable. Expert in VBA POWERPOINT Designing PowerPoint & Keynote presentations with custom made presentation slides, layouts & templates to transform your content into a visual journey beyond graphics.
$15 AUD dalam 1 hari
0,0 (0 ulasan)
1,2
1,2
Avatar Pengguna
Good day! The current prime minister of australia is Scott John Morrison. Can you send me demo of SQL database and excel file with form? I want to learn this task more detaled. I have good expirience in VBA and some expirience in SQL databases.
$15 AUD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hello, I already read your basic requirements. Then the prime minister of Australia is "Scott Morrison". With my experienced in used excel for data preparation and manipulation for next step transfer to database server. I can complete this job with full functionalities. Please consider me and share your requirements in detail. Regards,
$55 AUD dalam 2 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
 Having Around 1 Year and 11 Months of experience in VBA and RPA project using Blueprism.  Hands on Experience in Blueprism, VBA, EXCEL MACROS, MSSQL and MS-Access.  Have good knowledge in JavaScript, HTML and CSS.  Expertise in Design, developing and implementation of real time applications and automation projects  Performed testing and resolved all technical issues arising in the existing and new application.
$30 AUD dalam 2 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I have 5 years of experience n BI & ETL Background. So I can handle this project and deliver it within timeline, and it will be bug free. To your question, current prime minister of Australia is Scott Morrison.
$35 AUD dalam 2 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hello! The current prime minister of Australia is Scott Morrison. I have more than 8 years of experience in Excel, including VBA. Also I'm experienced in SQL. I will be glad to assist you in your project. Please feel free to ask me any questions you have. Sincerely yours, Simon
$15 AUD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hi, Scott Morrison is the current prime minister. Hi i'm pretty familiar with VBA and SQL. I looks simple what you've described however it's not so clear. Let me see the demo to better understand what do you need and after that we can discuss more. I don't make the promise that it'll be done in 3 hours because I had many situations when somebody stated (usually my boss :) ) that it will take 2-3 hours and it evolved into a few days.
$55 AUD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hi. smart project presentation. Scott Marisson the password. Now, I am working with VBA in excel a lot, and evem have some projects done. super fast and realiable. best wat to work in excel. also I have strong knowledges of using SQLite 3. let mw know ! Cheers
$20 AUD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera AUSTRALIA
Campsie, Australia
5,0
12
Memverifikasi Metode pembayaran
Anggota sejak Mar 29, 2014

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.