Em Andamento

Excel and Access Vlookup/Dlookup function

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

Habilidades: Processamento de Dados, Excel, Microsoft Access

Ver mais: excel dlookup, dlookup vlookup, excel vlookup access, property id, number function, function number, how to microsoft excel, Vlookup, excel vlookup, Excel to Access, excel row column, excel column row, excel property, finish data entry fast, column row excel, microsoft excel 2013, fileconvoy, simple dlookup function, vlookup data files, php function match data, access finish, data entry vlookup function, access data finish, simple access function, property excel

Acerca do Empregador:
( 37 comentários ) Los Angeles, United States

ID do Projeto: #5094659

Premiar a:

oFAZo

Short and sweet, can deliver in a less than 2 hours! Lets take it forward, ready to start **********

$30 USD em 0 dias
(10 Avaliações)
3.2

27 freelancers estão ofertando em média $23 para este trabalho

pkcyber

I will do this job with simple application. Applicaiton will take the excel and access file as input and iterate the excel data and see the respective data in access and update excel file. You can use this applicati Mais

$50 USD in 2 dias
(25 Comentários)
5.5
bouslimi1979

Dear, It will be done in 1-2 hours from now. I will proceed as you said but will use an sql query (junction) to get the correspondance between the Excel and Access records. After that will export the result to an Exce Mais

$25 USD in 3 dias
(40 Comentários)
5.3
NourElDeen

Dear Sir, I'm Expert on access. Kind Regards, NourElDeen

$15 USD in 2 dias
(27 Comentários)
4.4
permana22sl

Dear, I'm serious person, I can do the task accurately and perfectly. I understood this project's requirements exactly. I am representing my bid as a core interest and available to further discussion. I am waiting for Mais

$15 USD in 3 dias
(10 Comentários)
3.2
rumapaul

Dear sir, Greeting. After going through the project description , It will take two days to complete the task as because data is huge.I want to give you 100 % accuracy that's why i need two days [url removed, login to view] me an op Mais

$25 USD in 3 dias
(6 Comentários)
3.1
nikhiltechnology

Hi I can complete this task in a day. I an start immediately to finish all the record as per you requirement I am downloading you files. Send me chat message so that I can inform you when the job is completed Mais

$30 USD in 0 dias
(7 Comentários)
2.8
autom8ic

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.

$30 USD em 1 dia
(2 Comentários)
2.5
ajharul

Hello Sir, Thank you for this wonderful opportunity. I am writing in response to your advertisement for a “Excel and Access Vlookup/Dlookup function”. After carefully reviewing the experience requirements of the Mais

$15 USD in 3 dias
(5 Comentários)
2.4
rightfreelancer7

I am a professional software engineer. I am ready to take this work. It wont take more then 2hr for me to complete this task. my skill set and experience are best suitable for your requirement. Please assign this tas Mais

$25 USD in 3 dias
(5 Comentários)
2.3
chintu83

Lets start working without wasting a time with great accuracy and within a time deadline "Our Aim is to Satisfy Our Client By Our WORK"

$20 USD in 2 dias
(1 Comentário)
0.0
albertdlm

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.

$30 USD em 1 dia
(0 Comentários)
0.0
akila09

I will finish this project as your requested. please contact me asap,,, I will finish this project as your requested. I will finish this project as your requested. I will finish this project as your requested. I Mais

$26 USD em 1 dia
(0 Comentários)
0.0
IBTO

Hello, I suggest to create user interface in MS Access for data importing from MS Excel to MS Access. Special function will first create table then import data from excel sheet by sheet. At the end it will be po Mais

$25 USD em 1 dia
(0 Comentários)
0.0
js0ares

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.

$15 USD em 1 dia
(0 Comentários)
0.0
jianos

Δεν έχει γίνει καμιά πρόταση ακόμα

$20 USD in 5 dias
(0 Comentários)
0.0
precisiontechsl

Hello Sir I'm well aware of your requirement. It should be an easy job to accomplish. I have access to your files and should be able to get this done for your without any issues. Looking forward to get this proj Mais

$14 USD em 1 dia
(0 Comentários)
0.0
SirishaPeri

A proposal has not yet been provided

$25 USD in 3 dias
(0 Comentários)
0.0
azhar3083

I do my work with honisty. i need a work so please give this work to me. my skype ID is azharuddin.ansari83. so sir/miss give me this work. i make a new account on [url removed, login to view] i done this work in time limit. i have 1 Mais

$21 USD in 2 dias
(0 Comentários)
0.0
shabbirks64

Hi, I believe that I m good in Excel and can complete the assignment in an efficient and effective manner with in the stipulated time frame.

$25 USD in 3 dias
(0 Comentários)
0.0
pervaiztm

Heloo, I can do this project for you ,I assure that I will deliver this project within given time frame. regards Pervaiz

$20 USD em 1 dia
(0 Comentários)
0.0