Find Jobs
Hire Freelancers

Microsoft Access VBA MS SQL project. Import values from CSV files to Access / SQL database - 26/04/2018 09:12 EDT

$30-250 USD

Cerrado
Publicado hace casi 6 años

$30-250 USD

Pagado a la entrega
I have a Microsoft Access Desktop application with a MSSQL back end. The purpose of the application is to gather calibration data and to create a certificate (Word Document) Previously the operator used the MS Access front end to enter the data but now the data is being generated from the machine into a CSV file and I now need a process that will open the CSV file and import the values. The solution MUST be a desktop application using Microsoft Access with the SQL back end and VBA as the language inside the access application. There are 6 types of machine so each type will produce a CSV file and the structure is fixed (it always comes out in the same order). Each type has around 30 values in each record. Each type has it's own SQL table so there is a table for type 1 and a separate table for Type 2. The calibration file name will tell you the type and there is also a field in the record that will tell you the type of calibration. The process is the program will take a file from a predefined directory The name of the csv file will determine the type of calibration The relevant SQL table for that type is opened The CSV data values are mapped into the SQL table and a new calibration ID is generated that identifies that new calibration The new calibration ID from SQL is added to the CSV record to identify that that record has been processed The csv file is closed and moved out of the folder for storage in a "completed" folder at the end of the process the operation must be notified of all the new calibration ID for that run. This can be by email or any appropriate method as the operator has to check the calibrations and print the certificate. This process must be able to run in batch mode so the for example a calibration run is done at 9am and 2pm each day and the new certificate numbers sent to the operator There must also be a way to run it manually There are also some common errors and I can provide the list and if an error occurs the operation must be notified and the process move on but it is important that the operator gets a message so they can manually correct the errors Any questions please ask I don't see this as a complicated piece of work so i don't need project managers or designers I just need a VBA / Microsoft Access coder this is a private system that has customer data on it so i am not giving access for everyone. I will give access to one or maybe two contractors who can show they have a lot of VBA experience Thank you and please ask any questions
ID del proyecto: 16787552

Información sobre el proyecto

29 propuestas
Proyecto remoto
Activo hace 6 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
29 freelancers están ofertando un promedio de $191 USD por este trabajo
Avatar del usuario
Hello, I have the good knowledge of Microsoft Access VBA MS SQL project . I have more than 5 years of experience in Database Programming, Microsoft Access, Microsoft SQL Server, SQL, Visual Basic. We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$250 USD en 3 días
5,0 (254 comentarios)
8,1
8,1
Avatar del usuario
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Access and vba, of course, familiar. Give me a chance to show what I can do!
$200 USD en 4 días
4,9 (244 comentarios)
7,1
7,1
Avatar del usuario
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$166 USD en 3 días
4,7 (85 comentarios)
7,4
7,4
Avatar del usuario
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current " CSV files to Access / SQL database" project via Ms Access , very professionally and on time. Here is my introduction: I’m a ms Access/Excel/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL , including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$250 USD en 5 días
4,6 (65 comentarios)
6,5
6,5
Avatar del usuario
Hello Omac , I have read your project description and understood your requirement. I have 5 years experience in Excel VBA programming and can complete task within time with 100% accuracy.I am very responsible towards our clients. I know my client needs and importance. Skills : Excel, Macros,VBA,Web scraping,Web Search, Data entry, Copy typing, Transcription works,Wordpress,Megneto,Woocommerce,Shopify,Prestashop etc With Regards, Bhaskar.
$66 USD en 3 días
4,9 (90 comentarios)
6,1
6,1
Avatar del usuario
Hi I am interested in the project. I am an experienced MS Access application developer. I have developed many applications and have done many change requests here on freelancer. If interested in hiring me then please let me know so that we can discuss the timelines, budget and scope accordingly. Thanks Regards Jawad
$222 USD en 3 días
5,0 (92 comentarios)
5,9
5,9
Avatar del usuario
It will be manual import by clicking. Please share the MS-Access file and CSV sample for review. Thank you.
$250 USD en 3 días
5,0 (12 comentarios)
5,6
5,6
Avatar del usuario
Hi, I am a professional MS Access and SQL database developer with 5 years of corporate experience. I have gone through with all your points. I can assure you that I will meet your expectations easily. I am ready to start the project now and I will provide you a long term support whenever you required. The complete process: Import functionality: import the csv file data into a temp table. Run Multiple query to append your data into desired table.
$111 USD en 2 días
4,9 (39 comentarios)
5,8
5,8
Avatar del usuario
Hi, I am experienced on Microsoft Access , Excel and VBA. I can start your job immediately also. Please contact me to discuss the project in details. Thanks
$222 USD en 3 días
4,9 (11 comentarios)
4,7
4,7
Avatar del usuario
Hi, I'm a Microsoft expert with 10+ Years of Development experience in Microsoft technologies and have executed the various project and skill area are Web Application, Service Layers, API Integration and Desktop application. I have developed a wide range of applications using HTML, DHTML, ASP.NET, ASP.NET MVC, C# and VB.NET along with Databases such as SQL and MSAccess. Please do let us know if we can have a quick call to demonstrate few of our work done till date, and if you are satisfied with our skills we can take this further. Regards, Hetal Pushpa Mehta PS: Price is the placeholder for now. Final to be shared after discussion.
$155 USD en 5 días
5,0 (3 comentarios)
4,1
4,1
Avatar del usuario
Greetings, I'll be happy to assist you with this project. I have +15 years of Access/VBA /SQL experience and can will create a module in VBA along with a GUI form for the manual import process. Furthermore, this can be schedules to run at certain times, depending on your setup, in Windows Task Scheduler. Let's discuss.
$220 USD en 3 días
4,7 (14 comentarios)
4,2
4,2
Avatar del usuario
I have over 24 years experience creating database applications in both MS Access and MS SQL. I also have over 20 years experience with ETL development for both. I know I can create the solution you require. Please send a chat request so that we can discuss your requirements.
$250 USD en 10 días
4,3 (18 comentarios)
4,8
4,8
Avatar del usuario
Hello, I am interested in your project, I am a Senior .net Software Engineer with 6+ years of working experience in Software applications full life cycle. I have read your project description, and I can do what you need easily I used to communicate with CSV file types import, export and process data inside. I am expert in VBA,.Net 4.6, Asp.net, REST / SOAP web services, WCF, MVC 5, JavaScript, JQuery, Asp.net Web API, LINQ, Entity Framework, Amazon MWS, HTML, XML,CSS, PL/SQL , MS Access db. Actually, I am still building my profile here that's why I am offering a low cost, my only concern now is client satisfaction. I hope I can help you and it would be my pleasure to complete and deliver your task.
$35 USD en 3 días
5,0 (3 comentarios)
4,1
4,1
Avatar del usuario
Hi. I can complete the project in 2 days. Can I use C# program to do the project? It will be a windows program.
$166 USD en 2 días
4,9 (12 comentarios)
3,9
3,9
Avatar del usuario
Hi, I can finish the required project in Access I have done many projects usin it plz send me more details
$100 USD en 3 días
5,0 (7 comentarios)
3,8
3,8
Avatar del usuario
i have enough knowledge to convert csv file to sql server data pls message me sample data so that i can examine the columns very well on each file hoping the template of the files are all the same
$246 USD en 3 días
5,0 (1 comentario)
1,9
1,9
Avatar del usuario
Hi I had already done this type of similar project for a client in India its importing data from excel . Will like work with you on your project with the required result you expect. Looking forward to hear from you sir.
$166 USD en 3 días
5,0 (1 comentario)
0,6
0,6
Avatar del usuario
I have done similar migration/import of data to SQL Server databases. I am confident I will be able to deliver this on time.
$144 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Good day, I have a lot of experience programming in VBA applications, both in Excel and Access. CVS files are easily parameterizable text documents, and as you indicate, you already have the frontend, you only need to be able to import that data into SQL. Through an interface you can migrate this information without many complications. I am ready to collaborate in whatever you need.
$155 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$233 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Armagh, United Kingdom
5,0
32
Forma de pago verificada
Miembro desde jul 16, 2013

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.