Suljettu

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.

Taidot: C# -ohjelmointi, Excel, Microsoft Access, MySQL, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 1 arvostelu ) Los Angeles, United States

Projektin tunnus: #19322461

66 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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. Lisää

$220 USD 4 päivässä
(322 arvostelua)
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 Lisää

$211 USD 3 päivässä
(261 arvostelua)
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 Lisää

$120 USD 2 päivässä
(287 arvostelua)
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. Lisää

$250 USD 3 päivässä
(165 arvostelua)
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 Lisää

$150 USD 3 päivässä
(106 arvostelua)
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 Lisää

$250 USD 3 päivässä
(153 arvostelua)
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 Lisää

$333 USD 7 päivässä
(49 arvostelua)
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 päivässä
(128 arvostelua)
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 Lisää

$100 USD 3 päivässä
(63 arvostelua)
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 Lisää

$250 USD 7 päivässä
(66 arvostelua)
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 Lisää

$250 USD 3 päivässä
(50 arvostelua)
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 Lisää

$150 USD 3 päivässä
(57 arvostelua)
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 Lisää

$90 USD 1 päivässä
(75 arvostelua)
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 Lisää

$155 USD 3 päivässä
(7 arvostelua)
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 Lisää

$50 USD 3 päivässä
(43 arvostelua)
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 päivässä
(24 arvostelua)
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 päivässä
(16 arvostelua)
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 Lisää

$222 USD 10 päivässä
(2 arvostelua)
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 päivässä
(9 arvostelua)
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 Lisää

$277 USD 5 päivässä
(1 arvostelu)
3.3