WC Notif Manip

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.

Skills: Excel

See more: combined result, result number, process sheet, database using excel, using excel database, data process excel, database excel access, names excel database, extra fields, excel based database, excel names database, characters file, tables excel, field access using, shows excel, sheet names excel, sample excel sheets, sample excel sheet, process data sheet, output data excel, output access database, fields excel, excel sample database, excel output, excel number

About the Employer:
( 1 review ) Santa Barbara, United States

Project ID: #247511

Awarded to:


Quality work, please check PM.

$250 USD in 2 days
(1 Review)

4 freelancers are bidding on average $313 for this job


Please check the PM. Thanks...

$250 USD in 3 days
(0 Reviews)

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)

i will do this professionaly.

$250 USD in 3 days
(0 Reviews)