Find Jobs
Hire Freelancers

Create Access Database Utility - Compare Two Lists

$30-250 USD

Ukończony
Opublikowano ponad 6 lat temu

$30-250 USD

Płatne przy odbiorze
We are looking for a simple utility application that will compare two lists. It will preferably be created as an Access database, however we are open to other platforms, such as Excel VBA or Windows application. The user interface doesn't need to be pretty, just functional. The program will have two text input boxes (Box A and B), into which we can paste tab-delimited text, such as: John [tab] john@[login to view URL] Mike [tab] mike@[login to view URL] On pressing a button, the program will provide an output in three separate boxes: * "Only in Box A" -- The first box will show everything in Box A which isn't in Box B, using email address (column 2) as the unique identifier * "Only in Box B" -- The second box will show everything in Box B which isn't in Box A, using email address (column 2) as the unique identifier * "In Both Boxes" -- The third box will show those that are both in Box A and in Box B, using email address (column 2) as the unique identifier The output will be in a similar format as the input, with [name-column1] [tab] [email-column2] Please only bid if you're 100% certain of being able to do this. Also, please note that we will be using this program to process and compare around 100,000 email addresses, so it needs to work with volume! Thank you very much for your time. Also, please start your bid with "YOLO", so that I know you've read the project detail in full :-)
Identyfikator projektu: 15340046

Informację o projekcie

28 ofert
Zdalny projekt
Aktywny 7 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
YOLO Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. See my portfolio on Access. Graphical Reports [login to view URL] Email sending with MS Access. [login to view URL] Project Review Management System [login to view URL] [login to view URL] Email sending [login to view URL] EmployeeAffair Work [login to view URL] Hospital management system [login to view URL] RiskManagementSystem [login to view URL] Price might be negotiable during discussion. Pm me for more information and sample as well. Let me know the full specifications of the project. Thank you very much for your opportunity to bid. Royalcalif
$30 USD w 1 dzień
4,9 (99 opinii)
6,4
6,4
28 freelancerzy składają oferty o średniej wysokości $132 USD dla tej pracy
Awatar Użytkownika
YOLO Hi, my name's Paris. According to your project's description, you are looking for an app to compare two lists. I strongly suggest proceeding with a macro-enabled Excel spreadsheet. Relevant Skills and Experience I've got almost a decade experience in developing Excel spreadsheets and I am confident I can develop the app you are looking for. Actually, I am going to need about a day to deliver the file. Proposed Milestones $90 USD - The final and fully functional version is accepted by you. When is the right time to have a short chat? I am online from 3 to 11 pm (GMT+3).
$90 USD w 1 dzień
5,0 (379 opinii)
8,0
8,0
Awatar Użytkownika
"YOLO" As an expert vb.net developer, i am very much interested to develop a windows application using vb.net. I can do it by VBA also if you prefer, but vb.net would be best for this type of work. Relevant Skills and Experience vba, .net Proposed Milestones $49 USD - Initial $49 USD - Final Please let me know your preference of language for this tool.
$98 USD w 2 dni
5,0 (171 opinii)
7,3
7,3
Awatar Użytkownika
YOLO - I like this moto. You only live once. Looked at the details and I can do this program for you. Please open chat to discuss my approach. Thanks Aanvik Relevant Skills and Experience MSAccess Proposed Milestones $222 USD - Default
$222 USD w 3 dni
5,0 (54 opinii)
6,8
6,8
Awatar Użytkownika
YOLO We will need to get the pasted data in to two tables and then display three different queries in the required format. Relevant Skills and Experience I do exclusive MS Access and VBA projects on this platform. As you will see I have over 200 5 star reviews with repeat hire rate of over 25%. Proposed Milestones $155 USD - ON completion Please send me some sample text files with your data - I will create a trial database and send it back for your approval. You may then decide whether you want to accept my bid.
$100 USD w 3 dni
4,9 (157 opinii)
6,9
6,9
Awatar Użytkownika
YOLO Hi, I'm 100% certain that I'll solve your current "comparing " project successfully . Sure, it possible to make in Excel- I'm ready for that case , but Ms Access is a best solution in this case. Relevant Skills and Experience Ms Access, Ms Excel, VBA, ADO, SQL Proposed Milestones $155 USD - default
$155 USD w 3 dni
4,7 (80 opinii)
6,6
6,6
Awatar Użytkownika
YOLO Hey There, Why you want to use 2 input box when you can use the excel file to keep data and from there the VBA macro can do the task. Relevant Skills and Experience I am an excel/word/outlook VBA automation professional having 7+ years of experience Lets discuss/validate the complete requirement, budget and I can start to get this done with required quality Proposed Milestones $244 USD - Initial
$244 USD w 3 dni
4,9 (47 opinii)
5,6
5,6
Awatar Użytkownika
YOLO I would like to propose to developing your comparison system on MS-Access 2016, as it is easier to develop on MS-Access User will paste records and click on compare button to get the result. Relevant Skills and Experience I have been developing different application on MS-Access for more than 10 years. Proposed Milestones $50 USD - Initial $100 USD - Final The user will open the source file tab-delimited on MS-Excel and copy records to MS-Access's two list A and B and click on process button to get the result. Thank you.
$150 USD w 3 dni
5,0 (12 opinii)
5,6
5,6
Awatar Użytkownika
Yolo, I gone through the details. It seems it's easy to implement in windows application in C# My estimation is to complete the job is 3 hours. Please let me know. Relevant Skills and Experience 9 years experience in software development. Have done many projects like this. Proposed Milestones $50 USD - After delivery One question. As you told, the input email contains 10000 emails, why cannot keep the files in CSV and refer the CSV path n the app.
$50 USD w 2 dni
5,0 (14 opinii)
4,2
4,2
Awatar Użytkownika
YOLO Hello ... I'm Mina, As Senior Level software Engineer with more than nine years of experience in C++,C# I would bring a high quality and focused mindset to this job. Relevant Skills and Experience This project idea is very clear :) I have experience in: Managing and designing projects in C++, C#, VB.Net, VB6 Delivering with high quality based on careful testing Proposed Milestones $250 USD - Project Price I can deliver small sample with important features so you can validate the product step by step Mina
$250 USD w 3 dni
4,9 (2 opinii)
3,3
3,3
Awatar Użytkownika
YOLO I am very able to create this access database to cater your requirement
$156 USD w 4 dni
5,0 (3 opinii)
2,9
2,9
Awatar Użytkownika
YOLO - I have read the project description and understand that you would like to create a script to compare two lists with output in 3 boxes. Relevant Skills and Experience I am a professional and have worked on similar projects in Excel VBA. I have recently closed few projects in Excel VBA and would like to work on your project. Proposed Milestones $178 USD - Comparison Script in Excel VBA Please confirm the operating system and Excel version you are using.
$178 USD w 3 dni
5,0 (4 opinii)
3,0
3,0
Awatar Użytkownika
Hi. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now Relevant Skills and Experience I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle Proposed Milestones $150 USD - complete
$150 USD w 3 dni
5,0 (8 opinii)
2,7
2,7
Awatar Użytkownika
YOLO : I can do this in Excel using VB macros. Already worked out a sample that compares 2 lists and loaded in my Profile for you to see. I used 400,000 rows and the program runs in 14 seconds. Relevant Skills and Experience Degree in Computer science. 15 plus years of IT systems development in Virginia, London, Hong Kong & New Zealand. Now in good demand for teaching advanced Excel topics including VB programming. Proposed Milestones $80 USD - First draft solution delivered to you. $10 USD - Revised solution with corrections if any. $10 USD - Two weeks operations support as you use my new logic. Additional Services Offered $20 USD - Suggestions to improve your Excel system. $40 USD - My estimate of effort to implement the suggestions If you can kindly send me some sample data, (via chat in Freelancer) I can run that and send you back the result to give you better confidence before you make the decision reg awarding the project
$100 USD w 3 dni
5,0 (3 opinii)
2,7
2,7
Awatar Użytkownika
YOLO
$55 USD w 1 dzień
5,0 (1 opinia)
0,6
0,6
Awatar Użytkownika
YOLO (honestly though "tag" words like this are pointless, bots can track them nowadays). If you're open to alternatives this could be done in Google Sheets along with a few custom scripts. Relevant Skills and Experience - Google Apps Script - GSuite - HTML/CSS/Javascript Proposed Milestones $166 USD - Build a solution to compare lists of emails. What you require is a simple tool that can perform three set operations on two lists A and B. The difference A - B (everything in A that's not in B), the difference B - A (everything in B that's not in A) and the intersection of the two sets (emails that are in both lists). I can craft a solution to meet your requirements by creating code to perform these operations and generate a result set.
$166 USD w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
YOLO needed to be there as part of the description. Relevant Skills and Experience CLI + DB + App Development Proposed Milestones $170 USD - develop code Guaranteed Delivery
$166 USD w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
A proposal has not yet been provided
$166 USD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
YOLO i will build it in MS Access. Can be done with Query wizard. new to freelancer. Just wanna get some good rating. Feel free to contact me. Relevant Skills and Experience I built a MS access database for project management process. Familiar with import ,export query. familiar with VBA programming. this project will mainly use Query wizard. Find duplicates Query wizard.
$73 USD w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
YOLO Hi, Can do it in 30 minutes (in MS Access/VBA). Will give you a fully functional demo, if it works at your entire satisfaction we can please proceed for an official contract here. Relevant Skills and Experience More than 20 years experience in advanced Access, Excel, VBA automation and programming. You can please check a few sample projects in my portfolio (external references/links are not allowed here). Proposed Milestones $100 USD - MS Access/VBA Tool (To compare lists, email inputs) Have done more complex matching and comparison works in MS Access/VBA. You can please check the Web Extraction utility in my portfolio.
$100 USD w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
YOLO !! Hello; I have an Access app I use to find duplicates and homologate records results. I am sure it can be adapted to suit your needs. Best regards Relevant Skills and Experience + 35 years working with databases. Proposed Milestones $155 USD - Access app for data comparation
$155 USD w 3 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga UNITED KINGDOM
London, United Kingdom
5,0
642
Członek od sie 5, 2012

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.