已完成

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.

技能: 软件开发, ASP.NET, SQL

查看更多: 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

关于此雇主:
( 2个评论 ) Hook, United Kingdom

项目ID: #20721683

授予:

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. 更多

£470 GBP 在2天内
(85条评论)
7.8

45 威客就此工作平均出价 £465

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 更多

£500 GBP 在7天内
(17条评论)
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 更多

£350 GBP 在7天内
(20条评论)
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 在7天内
(17条评论)
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 更多

£750 GBP 在7天内
(5条评论)
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. 更多

£500 GBP 在7天内
(8条评论)
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 更多

£500 GBP 在7天内
(5条评论)
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 更多

£400 GBP 在3天内
(8条评论)
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 更多

£500 GBP 在7天内
(2条评论)
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 更多

£500 GBP 在7天内
(11条评论)
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 更多

£500 GBP 在12天内
(3条评论)
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 更多

£500 GBP 在4天内
(4条评论)
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 更多

£500 GBP 在7天内
(9条评论)
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 在7天内
(3条评论)
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 更多

£600 GBP 在5天内
(2条评论)
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 更多

£500 GBP 在7天内
(7条评论)
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 更多

£300GBP 在1天里
(8条评论)
3.9
£255 GBP 在7天内
(2条评论)
3.9
ganeshrasekar

I can do it ......

£250 GBP 在7天内
(10条评论)
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 在5天内
(2条评论)
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 在7天内
(5条评论)
3.6