Query Table Performance

[Steve Haack]

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

 

[Don Guillett]

Excel is not fond of large external databases