Question: does any one know t about how to find table through ado in vb6? 

Answer: select * from sysobjects where xtype='U' \n\nthis will give you list of all user defined objects - from which you can further filter down to tables.
This question from the Yahoo Q&A forum is categorized in the topic: Sports