Completed

Tool to import Excel spreadsheet into Contacts Database (SQL)

Hi

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.

Skills: Software Development, ASP.NET, SQL

See more: import excel sheet sql data base, import excel sql table, upload excel database sql server using, import excel data sql 2005, import excel joomla contacts, php upload import excel spreadsheet database, import excel sheet sql2005 database, import excel data sql database, import excel data sql database within sql, sql 2005 create job import excel spreadsheet sql, database function extract data xml file, contacts database sql, sql select data csv file perl script, import excel spreadsheet sql, import excel spreadsheet sql table, import excel workbook mysql database, import excel worksheet access database, import excel worksheet access database repost details repost

About the Employer:
( 2 reviews ) Hook, United Kingdom

Project ID: #20721683

Awarded to:

agilepksolutions

Hi I have understood your requirements completely. Can make small UI windows app which will accept excel file and import data in target database. I have 8 years of experience in .Net development using C# language. More

£470 GBP in 2 days
(85 Reviews)
7.8

45 freelancers are bidding on average £465 for this job

jastp

Hi there! I've read the details you mentioned and I'm interested in working on this project at very fair low cost with great quality! If you give us your few minutes for the chat then we can discuss some important poi More

£500 GBP in 7 days
(17 Reviews)
6.9
shaktistanwar

Hi I am a technical evangelist, developer and can do this task for you. I have more than 15 years of experience in software development and am a microsoft certified professional.I have strong work experience in Nopcomm More

£350 GBP in 7 days
(20 Reviews)
6.3
khp31

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.

£500 GBP in 7 days
(17 Reviews)
6.2
seekdeveloper

Hi, I have read your post and understood your requirement. Looking for the freelancer to work on your next project? Or just need some issues/bugs/fixes ASAP? I have 11+ years of experience and I'm here for you! My sk More

£750 GBP in 7 days
(5 Reviews)
5.9
graphicaa

can discuss all feasibility and scopes we have on this project. Please feel free to write me back with further details how you plan to model the whole thing. Let's talk. More

£500 GBP in 7 days
(8 Reviews)
5.9
langlangFan

Hello, I have much experience in C#, .NET development. I developed similar program in the past. I develop WCF, Win Forms, WPF program by using C#. I have solution to develop various kinds of applications such as financ More

£500 GBP in 7 days
(5 Reviews)
5.2
Bl1tz1t

Hi there! I'm an experienced software developer (10+ years). I already have developed tools/software to import Excel data into sql server, so I believe that I have the required skills to help you with your project. Bes More

£400 GBP in 3 days
(8 Reviews)
4.8
Ivan927

Hello! I am very interested in your post project. i am really looking for this kind of project for a long time in freelancer since i have rich experience on it. I think this project is very suitable for me and i am su More

£500 GBP in 7 days
(2 Reviews)
4.4
bestit4u

Hi sir, I see you're looking for a scrap developer proficient in C# to complete your job! Your project reminds me of one of my pervious project called "Amazon Scraper". It's a web scraper that get products informations More

£500 GBP in 7 days
(11 Reviews)
5.2
shivmirthyusl

IT FLEX SOLUTIONS has focused exclusively on the Web Development/Designing projects with 10+ years of service. Our Web Development/Designing expertise has helped clients to create e-commerce, social networking, real-es More

£500 GBP in 12 days
(3 Reviews)
4.4
mninfotech2

Hi there, recent similar work [login to view URL] username: admin password: in chat as you are looking for import spreadsheets of user information into a SQL database that has already been More

£500 GBP in 4 days
(4 Reviews)
4.6
xinglong717

Hi. How are you? I read your description carefully and am very interesting in your project. I can start right now and can help you. If you hire me,i will do my best for your job and you can get the best results. Lookin More

£500 GBP in 7 days
(9 Reviews)
4.1
Mickelson

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

£500 GBP in 7 days
(3 Reviews)
4.2
seaanddream

Hi, my name is Selim. I am from Solihull, UK. We provide all-in-one development solutions, including web development, web automation and web-based applications... We are specialized in php, java, python, and node.js. I More

£600 GBP in 5 days
(2 Reviews)
4.3
jayantavkumar

Proposal - I have gone through each and every word you mentioned in your project details. As per me, the SSIS ETL tool will be the best suit for your requirement. And the deduping and duplication record generation in C More

£500 GBP in 7 days
(7 Reviews)
3.7
ineedWorkJob

Greetings sir, I have read your project details and i will develop the desktop software tool that will run on windows computer where you can select the excel file to import, it will validate all the data if not mess More

£300 GBP in 1 day
(8 Reviews)
3.9
£255 GBP in 7 days
(2 Reviews)
3.9
ganeshrasekar

I can do it ......

£250 GBP in 7 days
(10 Reviews)
4.1
MrtDolphin

HI. I can import excel spreadsheet to db. I have full experience in it. I will use openXML and .NET. Please contact me. thanks in advance

£500 GBP in 5 days
(2 Reviews)
4.0
dailyhungama

Hi, I can do this work as per your requirement efficiently..Looking positively to work with you. BR, Prashanthi.R

£250 GBP in 7 days
(5 Reviews)
3.6