MS ACCESS - Data Extraction and Manipulation

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

Skills: Visual Basic, Windows Desktop

See more: data extraction manipulation access, data extraction manipulation, access data extraction manipulation, access data extraction, numbers access, data extraction access database, access data extract, relationships\, ms access, manipulation, find data, extract tables, database extraction, data-extraction, data visual, Data tables, data formatting, data format, C# access, c access, access, access c#, excel database visual basic, number manipulation, excel access table

About the Employer:
( 10 reviews ) Fort Collins, United States

Project ID: #234236

Awarded to:


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

$75 USD in 1 day
(2 Reviews)

5 freelancers are bidding on average $73 for this job


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

$50 USD in 1 day
(8 Reviews)

please see pm for details

$50 USD in 3 days
(2 Reviews)

Check PMB for detail.

$150 USD in 3 days
(0 Reviews)

this work can be done less then one day.

$40 USD in 1 day
(0 Reviews)