Create formatted excel files from data residing in MS Access
This project received 25 bids from talented freelancers with an average bid price of $160 USD.Get free quotes for a project like this
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"
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online