You're welcome. =)

>

D'oh

>thanks bonnie
>
>
>>Jim,
>>

>>oDataAdp.Fill(oDataSet, "Title")
>>

>>
>>~~Bonnie
>>
>>
>>
>>>I'm using the VFPOLEDB and after I fill my dataSet the Table name is not correct. Its defaulting to a generic name "TABLE
>>>
>>>oDataSet.tables("TABLE").rows(0).item("TitleID").tostring() ' works OK
>>>oDataSet.tables("TITLE").rows(0).item("TitleID").tostring() ' nothing
>>>
>>>Here is the code.
>>>thanks
>>>
>>>

Dim VFPDBCPath As String = ConfigurationSettings.AppSettings("VFPDBCPath")
>>>Dim oConnect As New OleDbConnection("Provider=VFPOLEDB.1;Data Source=" & VFPDBCPath & ";")
>>>sSelect = "SELECT TitleID FROM Title"
>>>Dim cSelect As New OleDbCommand(sSelect, oConnect)
>>>Dim oDataAdp As New OleDbDataAdapter(cSelect)
>>>Dim oDataSet As New DataSet, oDataRow As DataRow
>>>
>>>oDataAdp.Fill(oDataSet)