Find Jobs
Hire Freelancers

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

$10-30 AUD

Cerrado
Publicado hace más de 5 años

$10-30 AUD

Pagado a la entrega
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 del proyecto: 18648066

Información sobre el proyecto

22 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
22 freelancers están ofertando un promedio de $62 AUD por este trabajo
Avatar del usuario
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 en 3 días
4,9 (60 comentarios)
6,5
6,5
Avatar del usuario
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 en 2 días
4,9 (82 comentarios)
5,6
5,6
Avatar del usuario
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 en 2 días
5,0 (12 comentarios)
4,6
4,6
Avatar del usuario
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 en 1 día
4,9 (17 comentarios)
4,7
4,7
Avatar del usuario
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 en 2 días
5,0 (4 comentarios)
4,1
4,1
Avatar del usuario
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 en 1 día
5,0 (4 comentarios)
3,2
3,2
Avatar del usuario
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 en 1 día
5,0 (4 comentarios)
3,1
3,1
Avatar del usuario
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 en 0 día
5,0 (5 comentarios)
3,2
3,2
Avatar del usuario
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 en 3 días
4,4 (6 comentarios)
3,6
3,6
Avatar del usuario
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 en 0 día
4,7 (3 comentarios)
2,2
2,2
Avatar del usuario
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 en 3 días
4,4 (3 comentarios)
2,1
2,1
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
0,9
0,9
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
1,2
1,2
Avatar del usuario
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 en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
 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 en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
20 years VBA/SQL integration in a secure Health industry. Is Excel protected? Is SQL encrypted? Do you want all logic in SQL Stored procedure or Logic in VBA in Excel? Let me know. Thx Relevant Skills and Experience Access VBA, Excel, SQL, Ssrs reporting, data exchange experience.
$35 AUD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
i am a professional working in teradata, sql n hive
$25 AUD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Campsie, Australia
5,0
17
Forma de pago verificada
Miembro desde mar 29, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.