I have an MS Access db with records of products. The products have a unique identifier (SKU).
I need to have the ability to create Excel spreadsheets from the data in the db, formatted in a specific way, based on certain criteria.
I have a spreadsheet that I use to upload product details to Amazon.com. Amazon gave me a template that I must use (specific column headers, etc). Currently, when there are changes to my products (new products added, old products deleted, existing product details modified) I have to make all of those changes manually and then save the new file so I can upload it to Amazon.com. I want to be able to dynamically create that file so I do not have to manually do so.
I have eight (8) of these spreadsheets that I need the ability to create dynamically. Each one has a completely different set of column headers and fields but ALL of the data needed for all of the spreadsheets is in the db.
Most desired solution:
To have a page in my db with buttons:
"PS Web Export"
PDF Catalog Export"