Find Jobs
Hire Freelancers

Excel Compare With MSAccess

$10-30 USD

已完成
已发布大约 8 年前

$10-30 USD

货到付款
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.
项目 ID: 9990244

关于此项目

13提案
远程项目
活跃8 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在1天之内
5.0 (16条评论)
3.2
3.2
13威客以平均价$41 USD来参与此工作竞价
用户头像
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 在2天之内
5.0 (117条评论)
6.1
6.1
用户头像
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 在3天之内
5.0 (66条评论)
6.2
6.2
用户头像
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 在1天之内
5.0 (54条评论)
5.4
5.4
用户头像
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 在0天之内
4.9 (61条评论)
5.2
5.2
用户头像
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 在3天之内
5.0 (41条评论)
4.9
4.9
用户头像
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 在3天之内
5.0 (30条评论)
4.3
4.3
用户头像
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 在1天之内
5.0 (6条评论)
4.2
4.2
用户头像
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 在2天之内
0.0 (0条评论)
1.1
1.1
用户头像
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 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
I'm software developer and I've experience in developing apps that parse excel sheets and compare data
$25 USD 在5天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
NA, United States
4.5
25
付款方式已验证
会员自3月 2, 2014起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。