Automate and schedule MS Access query

Cerrado Publicado Oct 26, 2011 Pagado a la entrega
Cerrado Pagado a la entrega

I have a query that creates a table. It is a single simple SQL statement . The table is used as data in a pivot table in MS Excel.

What is needed:

1. Automate creating of Excel pivot table based on the query output. The data needs to be exported because the users will not be able to query it live. The data can be in an access db file or in excel. It will have more than 100,000 rows.

2. Automate filtering the output into multiple pivot tables based on the sales person in the data.

Ultimately I would like to kick this off with windows scheduler.

Arquitectura de software Administración de sistemas

Nº del proyecto: #3656964

Sobre el proyecto

2 propuestas Proyecto remoto Activo Nov 17, 2011

2 freelancers están ofertando un promedio de $63 por este trabajo

amcsummers

See private message.

$75.65 USD en 10 días
(53 comentarios)
5.3
quicksoftso

See private message.

$50.15 USD en 10 días
(3 comentarios)
0.0