S
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
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