Find Jobs
Hire Freelancers

Excel Compare With MSAccess

$10-30 USD

Suoritettu
Julkaistu noin 8 vuotta sitten

$10-30 USD

Maksettu toimituksen yhteydessä
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.
Projektin tunnus (ID): 9990244

Tietoa projektista

13 ehdotukset
Etäprojekti
Aktiivinen 8 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän 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 1 päivässä
5,0 (16 arvostelua)
3,2
3,2
13 freelancerit tarjoavat keskimäärin $41 USD tätä projektia
Käyttäjän 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 2 päivässä
5,0 (117 arvostelua)
6,1
6,1
Käyttäjän 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 3 päivässä
5,0 (66 arvostelua)
6,2
6,2
Käyttäjän 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 1 päivässä
5,0 (54 arvostelua)
5,4
5,4
Käyttäjän 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 0 päivässä
4,9 (61 arvostelua)
5,2
5,2
Käyttäjän 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 3 päivässä
5,0 (41 arvostelua)
4,9
4,9
Käyttäjän 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 3 päivässä
5,0 (30 arvostelua)
4,3
4,3
Käyttäjän 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 1 päivässä
5,0 (6 arvostelua)
4,2
4,2
Käyttäjän 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 2 päivässä
0,0 (0 arvostelua)
1,1
1,1
Käyttäjän 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 10 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
I'm software developer and I've experience in developing apps that parse excel sheets and compare data
$25 USD 5 päivässä
0,0 (0 arvostelua)
0,0
0,0

Tietoja asiakkaasta

Maan UNITED STATES lippu
NA, United States
4,5
25
Maksutapa vahvistettu
Liittynyt maalisk. 2, 2014

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.