Data Adapter question

[indydavid32]

I have the following code.

Dim datAdapt As New OleDb.OleDbDataAdapter("Select * From Weekly_Customers", Conn)
Dim commBuild As New OleDb.OleDbCommandBuilder(datAdapt)
        Dim datset As New Data.DataSet
        Dim datrow As Data.DataRow

This works fine. My questions is, say I have another table in the same database that Weekly_customers is in. Is there some command that I can use where I can just open that table with datAdapt, or do I have to declare a data adapter for each table in the database that I want to open?

Thanks