Second database/Excel question

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

If upon opening a report, the data refreshes from a
database on a network, and you're pulling in a lot of
records (1K+) and doing 4 loops to find data, is there any
way to speed up the process? This thing is taking a long
time to open and run the report. Help!
 
I suspect it depends on specifically what your code looks like now. If you
are doing selects and activates, then it can probably be made a lot faster.
 
I can't tell if there is a faster way with what you've said.

Depending on the schedule, think about making the database refresh an
overnight job, ready for you in the morning.
Maybe there is opportunity to reduce the number of loops?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refresh Bloomberg data in an excel file from a script 4
execution speed issue when closing files 5
Get results from Access Database. 1
Query multiple database platforms from Excel 4
Query Table Performance 1
Can't create a report from my query in Access 1
Macro speed decreesing after each run 6
Replacing Path/filename and criteria in MS Query based on cell contents using VBA 4

Back
Top