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

Answer 1

select * from sysobjects where xtype='U'

this will give you list of all user defined objects - from which you can further filter down to tables.

Answer 2

First you will need to set up an ado connection (connection object) to the database using a proper connection string. Once you have that you can access the table using a command object which you execute through your connection object. The command object can either have a reference to a stored procedure on the database or you can assign a text query to use.

Answer 3

Please be more specific, do you want a SQL query so you can find a table or you just want to connect to a specific database?