Færdiggjort

Mapping Import Files into Access DB

I have created a prototype, small DB in MS Access to help solve a data mapping and data transformation problem exists in our business.? Basically we are building a system to set between our Vendor's Databases (data files), our Web Shopping Cart, and our Inventory Management System.

I believe that I have created the core components of the database.? What i would like, for immediate commencement, is for someone to assist in developing an interface to this database.

The business problem is this:? Our vendors supply us data about their parts using their Part Number as the unique identifier. Unfortunately, we maintain a unique part number of our own design.? This new? database is designed to map the Vendor's part number to our unique part number.? I need an interface to the DB? built whereby we could browse for the XLS or CSV file supplied by our vendor and import it into the Access DB.? We need to provide for mapping of each vendor's fields to the appropriate fields in our newly created DB (about 8 fields in our DB).

## Deliverables

the files for import should be mapped to the table tblVendorParts.? I am providing a sample of one of the Vendor provided files for that requires mapping.

I would like to also have the coder create an export data mapping function as well.? I require the data from the database to be exported in a certain format to CSV and I also require data from the database to be exported in a certain MS Excel format.

I will provide samples of the export files that I would like to be able to recreate.? One of the files is for import into our inventory management database and the other file is for import into our Web Based Shopping cart.

Evner: Ingeniørarbejde, Microsoft, Microsoft Access, MySQL, PHP, Projekt Ledelse, Software Arkitektur, Software Testning, Visual Basic for Apps, Windows Skrivebord

Se mere: vendor database ms access, sample inventory system using php, prototype part 3, prototype map, php inventory system sample, parts inventory database, parts database access, ms access parts inventory database, ms access parts database, inventory system using php, excel for windows 8, developing a prototype, db import export, data access interface, building prototype, access vendor database, access parts database, what is ms access, ms excel help, export / import business

Om arbejdsgiveren:
( 5 bedømmelser ) United States

Projekt ID: #3320575

Tildelt til:

fastudiovw

See private message.

$63.75 USD in 9 dage
(736 bedømmelser)
7.5