Aug 01 2022 07:05 AM
Pulling data into Excel using MS Query from an ODBC DSN, the query hangs for 20 to 30 minutes every time I try to make a change to a parameter. This is on a PC of a user I am trying to help, and I'm connecting in remotely. The user tells me that the query is just as slow whether or not I'm connected in.
1. How can I speed up this query. It is almost impossible to help this person due to it's slowness.
2. Is it possible to edit the query on my PC and then port it over to another PC?
Thanks
Aug 02 2022 07:28 AM
Aug 02 2022 07:46 AM
Aug 02 2022 08:14 AM