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.