speed up distinct selection....

[sal21]

SQL = "SELECT DISTINCT ANNO FROM VIAGGIANTI_PTF ORDER BY ANNO"

i use thsi to selct distinct drom field ANNo but is very slow with 560.xxx records in fileds hereis other way(?!)
VBA code for Excel...

[HansV]

Do you have an index on the ANNO field? That should help.

Try either

SQL = "SELECT DISTINCT ANNO FROM VIAGGIANTI_PTF"

or

SQL = "SELECT ANNO FROM VIAGGIANTI_PTF GROUP BY ANNO"

If those aren't fast enough, you'll have to move to a faster computer or a faster database system.

[sal21]

Do you have an index on the ANNO field? That should help.

Try either

SQL = "SELECT DISTINCT ANNO FROM VIAGGIANTI_PTF"

or

SQL = "SELECT ANNO FROM VIAGGIANTI_PTF GROUP BY ANNO"

If those aren't fast enough, you'll have to move to a faster computer or a faster database system.

Yes i have index on ANNO and peraphs the second is a few fast!