Excel connected to external sql database is running slowly
- or -
Post a project like this2321
$$
- Posted:
- Proposals: 1
- Remote
- #1815507
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
Description of excel work: we need someone who knows Excel and SQL databases to troubleshoot the clients system remotely - likely using Teamviewer or similar technology.
Extra notes: we need this done this week.
Extra notes: we need this done this week.
Ben H.
100% (97)Projects Completed
66
Freelancers worked with
34
Projects awarded
29%
Last project
30 Nov 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Ben,
Have you or your client managed so far to identify if it is the SQL query that is running slow and causing the bottleneck, or if it is the processing in Excel/VBA of the result set that is causing it to run slow ? -
Is this Microsoft SQL Server? Is it local or remote?
Has it suddenly become slow or is this a new instalation
Rgs Cosma -
Can you advise the external database?
Ben H.05 Dec 2017There is more than one data source I believe but it is sql
552303551947551826
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