Ms Access VBA import from excel spreadsheet and run queries to append to existing table(s)
$30-250 USD
ชำระเงินเมื่อจัดส่ง
I have created (2) MS Access databases that I want help with similar functions.
Both databases I want to be able to have one command button that opens a file browser to locate the specific excel spreadsheet I want to import, have it add that spreadsheet to a temporary table so a query can be ran to remove new duplicates that may already be in the database. It would remove these duplicates based on several criteria.
So I would need someone to write the VBA for that command button. Also need a query built to remove duplicates based on certain criteria and then append it to the existing table.
Please let me know if you have any questions.
This is a project that I am doing for work to cut down on the steps of people having to combine spreadsheets and remove duplicates to better promote the databases that I have created.
Thank you,
หมายเลขโปรเจค: #18671634
เกี่ยวกับโปรเจกต์
มอบให้กับ:
Hi! I can help you create the required button with the code. What I am interested with is the query that removes the duplicates. Can you give me some sample data and criteria? Regards, Branislav Mihaljev
freelancer 15 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $149
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. เพิ่มเติม
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl เพิ่มเติม
With more then seven years of experience as a freelancer. I am a professional financial analyst. With more then five years of in KPGM world largest fourth number Accounting firm. I am expert in: - Making financial s เพิ่มเติม
Hello. Below are two my recently completed VBA projects. All are with positive feedback. Smart document update - https://www.freelancer.com/projects/data-entry/vba-excel-compare-count-sort/?w=f Document changes b เพิ่มเติม
Hello, I can do what you need. I have a long experience developing MS Access, my favorite office tool. Already performed, for you, a sample data base doing what you need, and I can share it. Thanks and regards.
Hi, my name is Esteban Salpeter and I'm an expert MS Access developer, with many years of experience on that platform. You can check out my portfolio to view some of my work. Your requirement is very clear, so the ne เพิ่มเติม
Hello I recently completed a similar Excel import for a UK Distribution company on the freelancer platform in MS Access 2016 using the import to temp table, manipulate data and append/update existing tables using VB เพิ่มเติม
Hi, I am expert in programming and have experience over 10 years in web design and web development and also testing automation and security over web application. I think I can do it for you as soon as possible.
Hi, I am vb.net developer thats why I am bidding. I had worked with ms access database also. how much I understand the project you need is that in a simple word you need a import functionalities in your application. im เพิ่มเติม
I can work for making command button and queries You can try me Thank you i hope we can work together in the new future
I use this exact approach in a number of information management databases. I can have this done for you in a few hours. I'm located in the NY metro area, on EST.