Kapalı

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

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

Beceriler: Veritabanı Programlama, Microsoft Access, Microsoft SQL Server, SQL, Visual Basic

Daha fazlasını gör: open locked microsoft files, kdb create historical database csv files, microsoft data engine mssqlmsfw service connect msde database isa server web filter logging, sql, excel, microsoft access, csv, microsoft data engine mssqlmsfw service connect msde database isa server web filter, automatically update database csv files, access database microsoft project using vba, update sql database csv asp, access database csv files, contractor database csv, goal database sports team class project, converting access sql server database, export sql database csv using vb6, asp sample project product category using access database, database hospital management free project adonet, populate database csv

İşveren Hakkında:
( 19 değerlendirme ) Armagh, United Kingdom

Proje NO: #16787552

Bu iş için 31 freelancer ortalamada $188 teklif veriyor

illuminesoft

We have successfully finished over 520 projects in last 18 years. ID : 16787552 Greetings, We are interested to work on this project, please find my comments inline with yours, 1. Microsoft Access VBA MS SQL pr Daha Fazla

in %bids___i_period_sub_35% gün içinde388%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(317 Değerlendirme)
7.5
schoudhary1553

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(110 Değerlendirme)
7.0
fabest

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 ser Daha Fazla

in %bids___i_period_sub_35% gün içinde166%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(81 Değerlendirme)
7.3
VladimirLilenko

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 possibl Daha Fazla

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(99 Değerlendirme)
6.1
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(70 Değerlendirme)
5.8
jawadaman

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 ple Daha Fazla

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(83 Değerlendirme)
5.8
zu02

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 file Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(50 Değerlendirme)
6.2
havit

It will be manual import by clicking. Please share the MS-Access file and CSV sample for review. Thank you.

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)
5.5
Webxpert4u

I am able to create online database so that multiple users can access into db and keep track. Now it will open the CSV file and import the values in DB. I have 7 years’ experience designing and developing Access databa Daha Fazla

in %bids___i_period_sub_35% gün içinde263%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
5.0
SBITServices

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 ve Daha Fazla

in %bids___i_period_sub_35% gün içinde66%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(42 Değerlendirme)
4.8
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(22 Değerlendirme)
5.0
fatimatuzzohura

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

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
4.4
ufologo22

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 ca Daha Fazla

in %bids___i_period_sub_35% gün içinde220%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)
4.2
dracopaladine

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. Pleas Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(18 Değerlendirme)
4.8
Astalavist4

Hi. I can complete the project in 2 days. Can I use C# program to do the project? It will be a windows program.

in %bids___i_period_sub_35% gün içinde166%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)
3.9
VBAautomation

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(14 Değerlendirme)
4.3
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(16 Değerlendirme)
3.8
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)
3.6
in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
3.3
alhassanlatif

Hi, I can finish the required project in Access I have done many projects usin it plz send me more details

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
2.9