I am looking for a tool that I can import spreadsheets of user information into a Contact Database which is using a SQL database. This tool must run from my Windows 10 desktop.
1. The tool must check the data first and output non-technical error messages for each column if it is missing data/formatting misaligned. i.e. "There cannot be a letter or special character in the phone number field"
2. Ths tool must first deduplicate the data before uploading into SQL dbo.LM_CLIENT table.
NO OTHER TABLES REQUIRE DATA IMPORTS
3. This tool must output the duplicates into a log file
4. I would require the source code so I can specify the connection string before debugging
5. Demonstrate to me on my Visual Studio 2019 environment how to amend the connection string.
6. Once debugged you must not be able to alter the connection string.
Spreadsheet with all fields included.
45 威客就此工作平均出价 £465
HI Employer, Myself Ketan. Sr. Developer having 10 plus years of experience. I have done similer kid of task in past projects. I can do this. Lets discuss more about this. Thanks.
Dear Customer! High-quality & Fast-delivery is promised! Area of Expertise: - C# I am fully experienced, I can assure you the best results and stay faster speed, please let me know. Regards