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.
66 freelance font une offre moyenne de $135 pour ce travail
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. Plus
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 Plus
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 Plus
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. Plus
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 Plus
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 Plus
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 Plus
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.
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 Plus
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 Plus
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 Plus
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 Plus
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 Plus
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 Plus
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.
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.
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 Plus
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.
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 Plus