Kapalı

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.

Beceriler: Yazılım Mimarisi, Visual Basic

Daha fazlasını görün: amazon db, create amazon upload file, create 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, export excel pdf, formatted, amazon sku, visual basic excel 2013

İşveren Hakkında:
( 14 değerlendirme ) Tucson, United States

Proje NO: #4454306

25 freelancer bu iş için ortalamada 160$ teklif veriyor

vnb400sl

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

in 10 gün içinde154$ USD
(108 Değerlendirme)
5.7
ZeusMan

Looking forward to working with you...

in 3 gün içinde165$ USD
(28 Değerlendirme)
5.0
northwolves

Ready to start.Provide more details,please.

in 3 gün içinde200$ USD
(29 Değerlendirme)
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

in 3 gün içinde147$ USD
(16 Değerlendirme)
4.5
adim

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

in 3 gün içinde143$ USD
(9 Değerlendirme)
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 Daha fazlası

in 5 gün içinde170$ USD
(4 Değerlendirme)
3.7
srdas2012

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

in 7 gün içinde218$ USD
(10 Değerlendirme)
3.3
vikashgadia

we can provide u the expert solution in record time

in 5 gün içinde198$ USD
(4 Değerlendirme)
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 Daha fazlası

in 5 gün içinde141$ USD
(5 Değerlendirme)
2.6
soikaushik2013

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

in 3 gün içinde110$ USD
(2 Değerlendirme)
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 Daha fazlası

in 3 gün içinde150$ USD
(2 Değerlendirme)
2.5
xeancaile

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

in 7 gün içinde110$ USD
(5 Değerlendirme)
2.2
msgpatel

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

in 7 gün içinde136$ USD
(1 Değerlendirme)
2.1
KreativeSys

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

in 10 gün içinde187$ USD
(2 Değerlendirme)
1.8
gojkid

Expert in building Stand Alone Desktop Applications using Java.

in 3 gün içinde55$ USD
(1 Değerlendirme)
1.1
SteveP495

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

in 5 gün içinde249$ USD
(0 Değerlendirme)
0.0
quyen21lx

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

in 5 gün içinde220$ USD
(0 Değerlendirme)
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 Daha fazlası

in 3 gün içinde93$ USD
(0 Değerlendirme)
0.0
sasindiv

Hi, Programmer with 8 years experience with Good experience in excel and Access DB. I have sent my proposal in personal message. Please look into it.

in 3 gün içinde137$ USD
(0 Değerlendirme)
0.0
indukuri09

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

in 4 gün içinde187$ USD
(0 Değerlendirme)
0.0