Закрыт

Database Admin / Expert for compare & deduplication of tables

I've got a large existing excel table that is growing out of control and has the potential of 500k+ rows of data .. At the same time I continue to gather more data and I need to be sure to test new the data against existing excel table --as to not duplicate or have multiple rows of exact data.

The right person should know how to

- create new SQL table from existing Excel/CSV files

- Compare the NEW SQL rows from the OLD SQL rows and remove specific rows with column data that matches old column data

- Remove NEW SQL Rows if the column data matches old SQL Table

I'm not a database expert, but I understand some basics of what I need done via EXCEL.

I'm not married to SQL if some C# SCRIPT or something else works, its fine by me.

Квалификация: Программирование на C#, Excel, Microsoft Access, MySQL, SQL

Показать больше deduplication using python, data domain sql server backups, deduplication sql database, how to remove duplicates in medline, python dedupe example, sql server backup deduplication, how to remove duplicates in database search, python code for deduplication, basic database admin php, csv files compare, oscommerce modify database admin, inurl login intitle database admin, database admin app iphone, flat file database admin, ajax add remove cell table database, freelance database admin options, creating database admin panel php, php slideshow database admin, oscommerce create database admin, database admin smartgwt

О работодателе:
( 1 отзыв ) Los Angeles, United States

ID проекта: #19322461

66 фрилансеров(-а) в среднем готовы выполнить эту работу за $135

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Больше

$220 USD за 4 дней(-я)
(322 отзывов(-а))
7.9
branislavm

Hello! I wonder... may I give a try with Access? I have developed a few systems to deduplicate the tables and I think I can re-use it. Also, importing from Excel is easy with Access. Can you send me one of your f Больше

$211 USD за 3 дней(-я)
(261 отзывов(-а))
7.4
sumon355

Hello, As an experienced C# developer and having sound knowledge in SQL & excel, i am very much interested to do this project. If i understand, i think you will need a data entry form and current excel data to be impo Больше

$120 USD за 2 дней(-я)
(287 отзывов(-а))
7.4
asin1987

Dear Employer, I understand you need to upload data in SQL DB from Excel so that you can add more data, keep a track of it and also you can remove duplicates overall. Please message me, I will do the job for you. Больше

$250 USD за 3 дней(-я)
(165 отзывов(-а))
7.4
polarjin2017

This is Excel /VBA result which I 've done [login to view URL] This is what i have done in Excel/VBA/MACRO. Just Crreating forms, query, Macro, custom formula, etc... I;ve done so many jobs in excel like l Больше

$150 USD за 3 дней(-я)
(106 отзывов(-а))
6.8
truongnguyen86

Hello there, i'm expert on SQL and database technology, i think 500k rows is big for excel but small to database, i've done many job with processing the data inside the database such as: finding rows, matching, remove Больше

$250 USD за 3 дней(-я)
(153 отзывов(-а))
6.7
FerriSoft1

Hi! I can do a windows app where you drag and drop your excel files, it will do the comparison add the different/new rows in a SQL Server database, and I'll code a button that will export that SQL Server Database back Больше

$333 USD за 7 дней(-я)
(49 отзывов(-а))
6.4
rinabuoy13

Hello, I am independent, experienced excel/c#/sql expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.

$100 USD за 3 дней(-я)
(128 отзывов(-а))
6.4
kipdev13

Nice to meet you. I've read the project description and can develop definitely. I'll provide you with the highly skilled & professional HTML/CSS, PHP/WordPress/CodeIgniter, JavaScript, MySQL, Front & Back-End Web Dev Больше

$100 USD за 3 дней(-я)
(63 отзывов(-а))
6.5
expertcoder1vw

Hi, I'm a database expert and have done de-duplication applications in the past and can do this per your requirements. It will be a Windows application, with a SQL database to store the data and process the duplicates Больше

$250 USD за 7 дней(-я)
(66 отзывов(-а))
6.1
zu02

Hi, there I hope all's well with you. Best way to make it via Ms Access - I can build very friendly ms Access app for your "growing data" I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all my pr Больше

$250 USD за 3 дней(-я)
(50 отзывов(-а))
6.1
hardikshah83

I can create this database for you along with required stored procedures. These procedures will enable you to do repeated tasks e.g. importing excel, clean-up and etc without any programming knowledge. Programmer with Больше

$150 USD за 3 дней(-я)
(57 отзывов(-а))
6.0
lightingdavid

Hello. I have good skills in "C# Programming, Excel, Microsoft Access, MySQL, SQL". I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project description carefully a Больше

$90 USD за 1 день
(75 отзывов(-а))
5.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 Больше

$155 USD за 3 дней(-я)
(7 отзывов(-а))
5.2
sajidkhan45

Hi, I really like how you ended that project description :) I am an excel VBA expert and can create a VBA script that would remove any duplicates when it is added to the excel file. Please go through my profile Больше

$50 USD за 3 дней(-я)
(43 отзывов(-а))
5.3
reedsystems

Hello, Your project caught my attention and I'd like to work with you. I can help you with duplicate removal in the said excel workbook.

$150 USD за 3 дней(-я)
(24 отзывов(-а))
4.8
bluesea1990

MySQL, ACCESS , EXCEL expert. I can complete your project successfully. I have many experiences in db developing and data mining. I'm software engineer and algorithm expert. Your task is suitable with me. Thanks.

$100 USD за 3 дней(-я)
(16 отзывов(-а))
4.2
honzucha

HI, My name is Jan Antos, I am 12+ years experienced Data Warehouse Architect and Business Intelligence developer. We can do a lot with your problem, we can also move the whole project from XLS to sql database and use Больше

$222 USD за 10 дней(-я)
(2 отзывов(-а))
4.2
freddyho

I am very good in Excel and Programming. I think your project is not difficult. This is my first bids after more than 5 years not active as freelancer.

$74 USD за 2 дней(-я)
(9 отзывов(-а))
4.2
mango953

Hello from Costa Rica. I offer you a database solution designed with FileMaker, an open source application very similar to MS Access, but better. But do not take my word for it, send your Excel file and I will clean al Больше

$277 USD за 5 дней(-я)
(1 отзыв)
3.3