Closed

Create formatted excel files from data residing in MS Access

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.

Skills: Software Architecture, Visual Basic

See more: amazon db, ms excel template, ms access 2013, create an excel, create amazon upload file, create a excel, amazon product upload file, amazon excel, excel export pdf, excel pdf fields, Amazon web architecture, export page excel, etc excel template, excel unique, excel based software, create access template, 2013 excel visual basic, amazon data template, amazon product template, export data web page, excel export template, excel modified, excel 2013 visual, changes data access, access 2013 buttons

About the Employer:
( 14 reviews ) Tucson, United States

Project ID: #4454306

25 freelancers are bidding on average $160 for this job

vnb400sl

i can develop an app in .NET to generate the excel file(s)

$154 USD in 10 days
(108 Reviews)
5.7
ZeusMan

Looking forward to working with you...

$165 USD in 3 days
(28 Reviews)
5.0
northwolves

Ready to start.Provide more details,please.

$200 USD in 3 days
(29 Reviews)
4.5
diegogarcia0531

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
(16 Reviews)
4.5
adim

More than 15 years experience in Excel, Access and VBA,

$143 USD in 3 days
(9 Reviews)
4.1
igorfreelancer

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

$170 USD in 5 days
(4 Reviews)
3.7
srdas2012

Hi We are Expert in this Type of Jobs ,Please see PMB

$218 USD in 7 days
(10 Reviews)
3.3
vikashgadia

we can provide u the expert solution in record time

$198 USD in 5 days
(4 Reviews)
2.8
FLinCanada

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

$141 USD in 5 days
(5 Reviews)
2.6
soikaushik2013

Hello, I'm interested to work in this project. Thanks

$110 USD in 3 days
(2 Reviews)
2.9
scubapro

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 expo More

$150 USD in 3 days
(2 Reviews)
2.5
xeancaile

consider it done.. please see PMB.. regards..

$110 USD in 7 days
(5 Reviews)
2.2
msgpatel

We have team of expert people to develop your database application.

$136 USD in 7 days
(1 Review)
2.1
KreativeSys

Hi we can do this task! We are good in Excel and Access!

$187 USD in 10 days
(2 Reviews)
1.8
gojkid

Expert in building Stand Alone Desktop Applications using Java.

$55 USD in 3 days
(1 Review)
1.1
sushant09in

I can handle this project very well. I have developed softwares which can read and write to excel files in formatted way. Kindly accept my bid.

$154 USD in 10 days
(0 Reviews)
0.0
SteveP495

Insto Trading and Finance Excel and VBA developer. Background in complex models. My pedigree in your PM. SteveP.

$249 USD in 5 days
(0 Reviews)
0.0
pinheirov

I provide my it service to accomplish the software requirements

$110 USD in 3 days
(0 Reviews)
0.0
XcelforU

I would like to complete your project. I am versed with MS Access and Excel VBA to complete your request. See PM for detailed info. Thanks!!

$165 USD in 3 days
(0 Reviews)
0.0
denadrajat

i'll do it for you.

$154 USD in 4 days
(0 Reviews)
0.0