Find Jobs
Hire Freelancers

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

$10-30 AUD

Zaprt
Objavljeno pred približno 5 leti

$10-30 AUD

Plačilo ob dostavi
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 projekta: 18648066

Več o projektu

25 ponudb
Projekt na daljavo
Aktivno pred 5 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
25 freelancerjev je oddalo ponudbo s povprečno vrednostjo $61 AUD za to delo
Avatar uporabnika
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 v 3 dneh
5,0 (23 ocen)
5,8
5,8
Avatar uporabnika
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 v 2 dneh
4,9 (74 ocen)
5,6
5,6
Avatar uporabnika
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 v 1 dnevu
4,9 (17 ocen)
4,7
4,7
Avatar uporabnika
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 v 2 dneh
5,0 (7 ocen)
4,1
4,1
Avatar uporabnika
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 v 2 dneh
5,0 (4 ocen)
4,1
4,1
Avatar uporabnika
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 v 1 dnevu
5,0 (4 ocen)
3,1
3,1
Avatar uporabnika
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 v 3 dneh
5,0 (3 ocen)
2,4
2,4
Avatar uporabnika
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 v 0 dnevu
5,0 (2 ocen)
2,0
2,0
Avatar uporabnika
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 v 0 dnevu
4,6 (2 ocen)
1,8
1,8
Avatar uporabnika
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 v 3 dneh
4,4 (2 ocen)
2,0
2,0
Avatar uporabnika
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 v 1 dnevu
5,0 (2 ocen)
1,0
1,0
Avatar uporabnika
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 v 1 dnevu
5,0 (1 ocena)
0,8
0,8
Avatar uporabnika
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 v 1 dnevu
0,0 (0 ocen)
1,2
1,2
Avatar uporabnika
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 v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 2 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
 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 v 2 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 2 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 3 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 1 dnevu
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava AUSTRALIA
Campsie, Australia
5,0
12
Plačilna metoda je verificirana
Član(ica) od mar. 29, 2014

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.