Hello,

can anyone tell me how I can get this to work with an excel file? I have sucessfully used this ActiveX script for .txt files but it just...

I've had that monitor one myself.  Worse thing was I was on out-of-hours support & was woken at 3am by the user to deal with it!

Thanks for your input.  I tried the test you mentioned above & I got the text appearing correctly.

However, I have now found that using isqlw, instead of isql, works.  It does...

Try...

select tbl_user.userID, tbl_user.username, count(tbl_visit.numerOfVisits)

from tbl_user, tbl_visit

where tbl_user.userID = tbl_visit.userID

group by tbl_user.userID, tbl_user.username