MI interface for clients to run Access queries from Excel
- or -
Post a project like this2778
£500(approx. $628)
- Posted:
- Proposals: 7
- Remote
- #1262747
- Completed
Description
Experience Level: Intermediate
I am using MS access to run Queries on a operating system via ODBC linked tables. I have set up some queries to enhance the data and create MI data tables.
To enhance the data I run access queries in a specific order. I would then point an excel pivot table at the tables created.
If it was just me I would open access, run the queries, then refresh the pivot.
But I want to give this to a client to run. So if possible I want to run the queries from excel and then refresh the pivot tables.
There will be some opportunity to improve the queries I have created! But I do not want to have them revamped to a point where I cannot understand them.
To enhance the data I run access queries in a specific order. I would then point an excel pivot table at the tables created.
If it was just me I would open access, run the queries, then refresh the pivot.
But I want to give this to a client to run. So if possible I want to run the queries from excel and then refresh the pivot tables.
There will be some opportunity to improve the queries I have created! But I do not want to have them revamped to a point where I cannot understand them.
Sam T.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
15 Sep 2016
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies