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 freelancers are bidding on average $135 for this job
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.
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.