WC Notif Manip

Completed Posted Apr 9, 2008 Paid on delivery

$250-750 USD

Paid on delivery

Completed Paid on delivery

Need an Access database that will take an Excel file containing two sheets, process them using two tables, and output them to an Excel file.

As you can see from the attached, the two source sheets are combined into the final single sheet, with a number of data manipulations done along the way, including normalizing similar fields, stripping extra characters, concatenating fields based upon the extra tables, revising the field names, and so on.

In the sample file attached, sheets "Input1" and "Input2" resemble the actual files from which we'll start, sheet "Tables" depicts the two tables that will need to be maintained in the Access database, and sheet "Result" shows how the final single-sheet Excel file will need to look.

Excel

Project ID: #247511

About the project

4 proposals Remote project Active Apr 9, 2008

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:

iliyant's Profile Picture
iliyant

Quality work, please check PM.

$250 USD in 2 days
(1 Review)
2.8

4 freelancers are bidding on average $313 for this job

Ishqh's Profile Picture
Ishqh

Please check the PM. Thanks...

$250 USD in 3 days
(0 Reviews)
0.0
tegerun's Profile Picture
tegerun

You can use the combination between MS ADO/DAO Library (for managing database) and MS Excel Object Model (for managing Excel worksheets and recordset inside). Using this combination you will be able to manage everythin More

$500 USD in 3 days
(0 Reviews)
0.0
prateek2008's Profile Picture
prateek2008

i will do this professionaly.

$250 USD in 3 days
(0 Reviews)
0.0
Post a project like this