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).
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.