Create formatted excel files from data residing in MS Access
$30-250 USD
Paid on delivery
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.
Project ID: #4454306
About the project
25 freelancers are bidding on average $160 for this job
Hi, I can do the job, MS Access expert, software developer for a several years I am looking forward to work with you Regards Diego
Hi sjonas41! I have 20+ years of experience in coding and designing data mining and transformation apps and 10+ years of coding in .net. I can produce a .NET app (console or gui) that will create the desired excel fil More
Do you have to do this from the Access side? That would work, and I can do it for you, but recent versions of Access don't handle newer Excel formats well. What about an Excel based tool that reads the tables from Acc More
Insto Trading and Finance Excel and VBA developer. Background in complex models. My pedigree in your PM. SteveP.
I have over 15 years of experience in working with Excel, Access and VBA. These skills were the primary skills in all the projects.