Project Detail

MS ACCESS - Data Extraction and Manipulation

MS ACCESS - Data Extraction and Manipulation is project number 234236
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: MsVBA

Budget: $30-250

Created: 03/06/2008 at 11:27 EST

Bid Count: 5

Average Bid:
$ 73

03/07/2008 at 11:27 EST

Project Creator: thefarewellnote offline
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (10 reviews)

Description

For this project you will be working with Access 2003 and doing some basic data manipulation and then extracting the data from MS Access to Excel files (.xls) and storing them in a folder.

1. Currently there are approx 30 tables. 10 of those tables are called "relationship" tables that show the relationships from one table to another.

The normal files have the following columns
1. Type
2. Name
3. ID

The "relationship" tables have the following columns in them.
1. Type
2. FromName
3. ToName

The FromName and ToName contain an ID number (column) that matches an ID number (column) in the other tables. You will need to run a simple to find that ID in the normal table and get the Name value that corresponds to that ID. Once you have that name you will replace the FromName and ToName with the matching name from the normal tables.

2. Once that step is completed it will extract all the tables and relationship tables out of the database into .xls format keeping the formatting of the tables.

3. Close the Access Database

Report Violation

Job Type

See more: access, data, data extract, data extraction, database, excel, excel file, extract, extraction, format, formatting, ms access, number, project, simple

Messages Posted:1

If you are the project creator or one of the bidders Log In for more options

PMB

1 day

03-06-2008 11:38 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(35 reviews)

Hi, I think the whole work can be done in Excel itself.

tindz99 offline

3 days

03-06-2008 12:32 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(11 reviews)

please see pm for details

MsVBA offline

1 day

03-06-2008 11:39 EST

9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10
(2 reviews)

Thanks for the invite! I'm available to complete this project immediately. Let's get started! (Ms. VBA)

ammar83 offline

150

3 days

03-06-2008 11:32 EST

(No Feedback Yet)

Check PMB for detail.

onlyajayu offline

1 day

03-06-2008 11:52 EST

(No Feedback Yet)

this work can be done less then one day.

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.