Query Table Performance
 

All,
I have an Access 2007 Database with about 300,000 recoreds in it. I have
built some queries in the database that will find the recoreds I need VERY
quickly (1-2 seconds to find 12,000-15,000 records, on average).

I am using Excel 2007 to build some charts to reports on the data, so I have
a linked table, which I change the query on, depending on the data that I
want to see.

My problem, is that in Excel, it is taking 5 minutes to update the data when
I change the table to point to a diferent access query and refresh the data.

Can someone point me to some guidance on how to improve this performance in
Excel?

Thanks,
Steve

Query Table Performance
 

It is not the query that uses most of the time, it is the links and the
calculations on the worksheet that uses the most amount of time.
Sometimes can run faster then using links on the worksheet. Yo can use
a Query Update Event to start the macro so it will automatically run.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=150834

Microsoft Office Help

Query Table Performance
 

Excel is not fond of large external databases

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve Haack" wrote in message
...
All,
I have an Access 2007 Database with about 300,000 recoreds in it. I have
built some queries in the database that will find the recoreds I need VERY
quickly (1-2 seconds to find 12,000-15,000 records, on average).

I am using Excel 2007 to build some charts to reports on the data, so I
have
a linked table, which I change the query on, depending on the data that I
want to see.

My problem, is that in Excel, it is taking 5 minutes to update the data
when
I change the table to point to a diferent access query and refresh the
data.

Can someone point me to some guidance on how to improve this performance
in
Excel?

Thanks,
Steve