Find Jobs
Hire Freelancers

Database Query

$30-100 USD

In Progress
Posted over 17 years ago

$30-100 USD

Paid on delivery
I have an access file with two tables. One has multiple email addresses and domain names. The other table has contact information and domain names. I need to do join between the two tables where the first name from the one table is LIKE the email address from the other table. I have uploaded an example excel file to give you an idea on what I need to do. In the attached example I sheet1 has the email addresses and sheet2 the contact information. You will see in sheet2 that the "first" field contains Rick and then in sheet1 there is an email address "rickatthesweeperdotcom". I would need a query that will query the two tables and then update sheet2 with the ex_email "rickatthesweeperdotcom" because ex_email is LIKE rick. The actual size of the tables in access are sheet1 - 20,000 and sheet2 3,000. Anyway, can this be done. What would the cost be? Can you also make it so that it will query between the tables on "last" to find email addresses that match the last names?
Project ID: 118091

About the project

10 proposals
Remote project
Active 17 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED STATES
Thousand Oaks, United States
5.0
150
Payment method verified
Member since Aug 9, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.