Find Jobs
Hire Freelancers

Extract info from excel files into Access DB

$30-5000 USD

Completed
Posted over 15 years ago

$30-5000 USD

Paid on delivery
I have a folder full of excel files, all in the same format, but with different, and sometimes duplicate data. I need a small program to extract this data, warn if is not consistent with what is in the database, and add to the database if it does not exists. Looking at about 12 unique fields in each file and then another 50 that are essentially the same. I've attached a sample excel file, the access template that I would like filled in, and a mapping between the two. A program where I can a) select the database, and the b) select and add each file indivisually would be fine. Adding all the files in the directory would be a bonus.
Project ID: 3119335

About the project

2 proposals
Remote project
Active 16 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
Awarded to:
User Avatar
See private message.
$63.75 USD in 14 days
4.8 (49 reviews)
5.0
5.0
2 freelancers are bidding on average $159 USD for this job
User Avatar
See private message.
$255 USD in 14 days
4.9 (409 reviews)
7.1
7.1

About the client

Flag of UNITED STATES
Bonita Springs, United States
5.0
131
Payment method verified
Member since Oct 25, 2004

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)
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.