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 Free Trial For New Buyers
 

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
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (10 reviews)

Bid On This Project
 

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

Messages Posted:1 View project clarification board Post message on project clarification board

Bid On This Project
 

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

 

50

1 day

03-06-2008 11:38 EST

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

help

 

50

3 days

03-06-2008 12:32 EST

please see pm for details

help

 

75

1 day

03-06-2008 11:39 EST

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

help

 

150

3 days

03-06-2008 11:32 EST

(No Feedback Yet)

Check PMB for detail.

help

 

40

1 day

03-06-2008 11:52 EST

(No Feedback Yet)

this work can be done less then one day.

help


    Bid on this Project