ADO's question

I can use ADO to access the database through ODBC.But I want to know
the table's name and the columns' name. What shall I do?

Take a look at the schema methods. Tey will give you the information you are looking for.