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")

~~Bonnie

>I have the following code:
>
>

>      Dim loData As DataSet
>      loData = New DataSet
>      Dim loDT As New OleDbDataAdapter("select * from Login into cursor Temp", _
>      "Provider=VFPOLEDB.1;Data Source=D:\Login.dbf;Password='';Collating Sequence=MACHINE")
>
>      loDT.Fill(loData)
>
>      ' Get it into a view
>      Dim loView As DataView
>      loView = loData.Tables("Temp").DefaultView
>

>
>I get the message "Object reference not set to an instance of an object" on the last line. The cursor Temp exists. So, why is it not recognized?