Create formatted excel files from data residing in MS Access

Closed Posted Apr 22, 2013 Paid on delivery
Closed 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.

Software Architecture Visual Basic

Project ID: #4454306

About the project

25 proposals Remote project Active May 29, 2013

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
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
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
denadrajat

i'll do it for you.

$154 USD in 4 days
(0 Reviews)
0.0
radhakrishnan1

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 Reviews)
0.0
indukuri09

i am very good VB programmer and good with MS access. Let me know more details. Thanks,

$187 USD in 4 days
(0 Reviews)
0.0
quyen21lx

I am an expert of VB, MS Access. I ready to start work now.

$220 USD in 5 days
(0 Reviews)
0.0
anujak999

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 More

$93 USD in 3 days
(0 Reviews)
0.0