Closed

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
Employer working
Project Budget
N/A
Total Bids
25
Project Description

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.

Example 1:
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:
"Amazon Export"
"PS Web Export"
PDF Catalog Export"
etc.

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online