Query or table for faster data retrieval?

[klar]

Dear Access experts,

I am retrieving data from Access into Excel through ADO. It is quite
slow. The data are retrieved from an Access queries. Will it be much
faster to retrieve data directly from tables instead of queries? I
should think table will be faster but I am not sure how much faster.
As it entails quite a bit of work on the Excel side to retrieve
directly from tables, I would like to ask the experts here whether the
increased speed is just a little or much more or not much at all(not
noticeable).


Thank you very much.

 

[HiTechCoach]

With ADO you are always using a query. When you specify just a table name the JET or ACE database engine converts it into a "select all" query or "Select tablename.* From tablename;"

Things that can make a query slow:

1) pulling lots of fields form many tables
2) lots of calculations, or Domain functions like Dlookup()
3) sorting on a none indexed field


If you don't need all the field from the table(s) then a query will be faster since you can limit the the amount of data to just the fields you need.