I need a very simple windows desktop application that will retrieve a .csv file from a directory specified by an ini file and parse the file contents. It should then update a sql server table based on the file contents and delete the file. sql connection details should also be in ini file. It is 2008 sql server express.
The app should perform the following with the file contents:
1) locate existing records in the table and update based on contents of the file.
2) Add new records that are not found in the table
3) Remove any records from the table that are not in the file based on ID_ITEM in the file
The app will be set up to run automatically from windows scheduler on an hourly basis therefore any error messages must be logged to an error log, no error messages, popups can be generated.
Need this done today!
database table script and the csv file are attached.
This is a very simple app, no frills. Couple hours work if you know what you are doing. You must be ready to get started immediately and complete it quickly. I will be ready to test it as soon as you finish it.
11 freelancers are bidding on average $119 for this job
Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)
4 years experience in desktop application and 3 years experience in web application. I am willing to work with sir. You can assure 100% customer satisfaction.
We are a team of 2 having a vast experience on excel VBA scripting with database connections. Looking forward to work with you. thanks !!! Please have a look at our message in your PMB.