I have an excel file with over 7 million rows (in 20+ excel sheets) that are identified by a "property ID" number, and then some information in the same row. I also have a microsoft access file that has 23 million rows with "Property ID" in one column, and "Owner Name" in another column. I want to match and put the corresponding "Owner Name" from the access file, next to the correct excel row in the "Owner Name" column in the excel file.
I think this is a simple task and can be accomplished by importing the excel data into access, then using Dlookup function, then exporting it back to excel.
Here are the two files:
Excel File: [url removed, login to view]
Access File: [url removed, login to view]
If interested, let me know how fast it will take you to finish and to send me the output file
27 freelancers are bidding on average $23 for this job
Hello. I can put corresponding Owner Name from the access DB to the Property IDs of your excel file. I can do this by writing a short quick script. This can be completed in a day.
I have extensive experience in using MS Access databases. I am good at MS Excel and an expert with Excel Macros and VBA. Would definitely be able to do the job as per the brief specs provided within 1 day.
Hi I work daily with excel and access so i can mastered both tools. I also use VBA with some frequency as a way to assist in certain functions which allows also to leverage these tools.