Find Jobs
Hire Freelancers

Excel Compare With MSAccess

$10-30 USD

Completed
Posted about 8 years ago

$10-30 USD

Paid on delivery
I run a data extract daily for a set of users from one system, and import that list into a separate system. Each day the file gets larger and larger and takes more time to import/fix after it is imported. I am looking for a way to compare all columns in 2 excel sheets and only get the results of new users that were added, and also get the full row if any changes were made in any column for a user. For instance if you have the below sheets: First Last UserID Auser AA AAAA Buser BB BBBB Cuser CC CCCC First Last UserID Auser AA AAAA Buser BBBA BBBB Cuser CC CCCC Duser DD DDDD The only results I should get should be the Buser due to the change in last name, and the Duser as this is a new user. First Last UserID Buser BBBA BBBB Duser DD DDDD Let's say I have 15 column headers and need to compare them all, and roughly 300,000 rows. I need them all compared.
Project ID: 9990244

About the project

13 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Dear Job Poster! As a VBA/Access/Excel automation expert, I will write you a code that compares your data and only uploads fresh records, or modify ones that have changes in it. I can complete this task in a matter of approximately two hours, and you will have a clean, professional solution for your database. Raeve
$35 USD in 1 day
5.0 (16 reviews)
3.2
3.2
13 freelancers are bidding on average $41 USD for this job
User Avatar
Hello, I am very much interested to do this work as i have strong knowledge in excel vba as well ms access related works. Looking forward to have a positive response from you. Thanks
$30 USD in 2 days
5.0 (117 reviews)
6.1
6.1
User Avatar
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi
$120 USD in 3 days
5.0 (66 reviews)
6.2
6.2
User Avatar
Hi I am interested in this project. I am an experienced MS Access applications developer. I can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines and budget accordingly. Thanks regards Jawad
$35 USD in 1 day
5.0 (54 reviews)
5.4
5.4
User Avatar
I can create simple desktop application where you'll select two Excel files and after you press Start button it will compare data row by row (on some key column) and generate another Excel file with the difference between files. All I need to start is couple of sample files and milestone payment from you. Thanks. Roman
$34 USD in 0 day
4.9 (61 reviews)
5.2
5.2
User Avatar
Hello, I am Excel and VBA expert. I can write macro for this task. Are you comparing the same rows with 2 sheets (ie, first row of the first sheet with first row of the second sheet, row 2 to row 2, and so on) Please note that I have 100% completion rate and 5-star feedback on projects.
$35 USD in 3 days
5.0 (41 reviews)
4.9
4.9
User Avatar
I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details
$35 USD in 3 days
5.0 (30 reviews)
4.3
4.3
User Avatar
Hello, Over the past 18 years, I’ve worked in a variety of functions spanning Information Technology, Supply Chain, Finance and Process Optimization with a key point of connectivity being my use of MS Access/Visual Basic to solve many of the problems presented in each role. You can see more details on my educational and professional background on my LinkedIn profile (Rob Sliter), if you choose. I’ve built numerous applications varying from simple reporting tools to more complex multi-user client-server applications used in production environments. I am very motivated to exceed your expectations, earn a great review from you to post on the website, and begin a long standing business relationship. Your projects sounds interesting and I believe that my background will allow me to provide additional perspectives and insights that you will find valuable. Whether you're looking for Access development, Excel automation through VBA, or data analysis, synthesis, and presentation - I believe I'm the resource that you're looking for. Thanks for your consideration, Rob
$30 USD in 1 day
5.0 (6 reviews)
4.2
4.2
User Avatar
Hi, PRICE is negotiable based on deadline and demand. I teach epidemiology and biostatistics as assistant lecturer. I like SPSS,Stata and VBA. I have a PhD and my IF is above 11. I can perform and interpret uni and multivariate analyses. I am fast and accurate.
$35 USD in 2 days
0.0 (0 reviews)
1.1
1.1
User Avatar
Hi, I'm interested to help you for your project. I'm a French software engineer since 2006. If Excel is not mandatory, I think we can find another way to solve your problem. For example (It's not the final proposal), we can use Talend (it's a open source software to process data). Talend job could be launch with Windows Task Manager. The treatment could be: 1°) Extract data from Access DB. 2°) If export file doesn't exist, generate it. 3°) If export file exist, generate the file wihout duplicate data. Maybe you want a "real" software. In this case we can use the same treatment. An advantage is that we can easily use the source code to add new features. I am available for any questions or comment. Best regards, Nicolas
$35 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm software developer and I've experience in developing apps that parse excel sheets and compare data
$25 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
NA, United States
4.5
25
Payment method verified
Member since Mar 2, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.