Đã Đóng

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.

Kĩ năng: Lập trình C#, Excel, Microsoft Access, MySQL, SQL

Xem nhiều hơn: 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

Về Bên Thuê:
( 1 Nhận xét ) Los Angeles, United States

ID dự án: #19322461

66 freelancer đang chào giá trung bình $135 cho công việc này

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. Thêm

$220 USD trong 4 ngày
(322 Nhận xét)
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 Thêm

$211 USD trong 3 ngày
(261 Nhận xét)
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 Thêm

$120 USD trong 2 ngày
(287 Nhận xét)
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. Thêm

$250 USD trong 3 ngày
(165 Nhận xét)
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 Thêm

$150 USD trong 3 ngày
(106 Nhận xét)
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 Thêm

$250 USD trong 3 ngày
(153 Nhận xét)
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 Thêm

$333 USD trong 7 ngày
(49 Nhận xét)
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 trong 3 ngày
(128 Nhận xét)
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 Thêm

$100 USD trong 3 ngày
(63 Nhận xét)
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 Thêm

$250 USD trong 7 ngày
(66 Nhận xét)
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 Thêm

$250 USD trong 3 ngày
(50 Nhận xét)
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 Thêm

$150 USD trong 3 ngày
(57 Nhận xét)
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 Thêm

$90 USD trong 1 ngày
(75 Nhận xét)
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 Thêm

$155 USD trong 3 ngày
(7 Nhận xét)
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 Thêm

$50 USD trong 3 ngày
(43 Nhận xét)
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 trong 3 ngày
(24 Nhận xét)
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 trong 3 ngày
(16 Nhận xét)
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 Thêm

$222 USD trong 10 ngày
(2 Nhận xét)
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 trong 2 ngày
(9 Nhận xét)
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 Thêm

$277 USD trong 5 ngày
(1 Nhận xét)
3.3