Find Jobs
Hire Freelancers

Create formatted excel files from data residing in MS Access

$30-250 USD

Closed
Posted almost 11 years ago

$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 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
25 freelancers are bidding on average $160 USD for this job
User Avatar
i can develop an app in .NET to generate the excel file(s)
$154 USD in 10 days
4.9 (108 reviews)
5.7
5.7
User Avatar
Looking forward to working with you...
$165 USD in 3 days
5.0 (28 reviews)
5.0
5.0
User Avatar
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
$147 USD in 3 days
4.9 (16 reviews)
4.5
4.5
User Avatar
More than 15 years experience in Excel, Access and VBA,
$143 USD in 3 days
4.9 (9 reviews)
4.1
4.1
User Avatar
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 files either as csv files or a fully formatted xlsx files. I guarantee a final product to your exact specifications, polished and fully tested, within a budget and a timeframe of my bid! Please check PM for more.
$170 USD in 5 days
5.0 (4 reviews)
3.7
3.7
User Avatar
Hi We are Expert in this Type of Jobs ,Please see PMB
$218 USD in 7 days
5.0 (10 reviews)
3.3
3.3
User Avatar
we can provide u the expert solution in record time
$198 USD in 5 days
5.0 (4 reviews)
2.8
2.8
User Avatar
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 Access and formats the data appropriately? The tool would then save the individual worksheets in whatever form Amazon required (csv, xls, xlsx, etc.). Please discuss if you are interested. Also please read my note.
$141 USD in 5 days
4.9 (5 reviews)
2.6
2.6
User Avatar
Hello, I'm interested to work in this project. Thanks
$110 USD in 3 days
3.5 (2 reviews)
2.9
2.9
User Avatar
Dear Sir, This can be created in .NET quite easily, so I would suggest a .NET application, with a nice GUI and user friendly, that connects to your Access database, uses multiple SQL's to get the required data and export it to Excel. Kind regards, Scubapro.
$150 USD in 3 days
5.0 (2 reviews)
2.5
2.5
User Avatar
consider it done.. please see PMB.. regards..
$110 USD in 7 days
4.8 (5 reviews)
2.2
2.2
User Avatar
We have team of expert people to develop your database application.
$136 USD in 7 days
4.8 (1 review)
2.1
2.1
User Avatar
Hi we can do this task! We are good in Excel and Access!
$187 USD in 10 days
5.0 (2 reviews)
1.8
1.8
User Avatar
Expert in building Stand Alone Desktop Applications using Java.
$55 USD in 3 days
5.0 (1 review)
1.1
1.1
User Avatar
Insto Trading and Finance Excel and VBA developer. Background in complex models. My pedigree in your PM. SteveP.
$249 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i'll do it for you.
$154 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have over 15 years of experience in working with Excel, Access and VBA. These skills were the primary skills in all the projects.
$247 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i am very good VB programmer and good with MS access. Let me know more details. Thanks,
$187 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an expert of VB, MS Access. I ready to start work now.
$220 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, I am 6+ years experienced programmer. I can do the job in short span and low cost. For this a desktop based application i will develop having buttons you mentioned with the desired functions. Kindly grant me the opportunity to work with you. Regards
$93 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Tucson, United States
5.0
14
Payment method verified
Member since May 8, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.