You're welcome.
Yeah, without specifying the table name in the .Fill(), it would default to "table".
~~Bonnie
>>How do you know Table "Temp" exists? I don't think it does, given the code you've shown. Try this instead:
>>
>>...
>> Dim loDT As New OleDbDataAdapter("select * from Login", _
>> "Provider=VFPOLEDB.1;Data Source=D:\Login.dbf;Password='';Collating Sequence=MACHINE")
>>...
>> loDT.Fill(loData, "Temp")
>>
>
>Thanks, I was not aware it could be done like this.