... 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
> 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 >>