I
info
Hi!
Are there any possibilities to open and process an DBase / Visual
FoxPro Table ?
Are there any possibilities to open and process an DBase / Visual
FoxPro Table ?
Earl said:You can do it with an ODBC connection:
Dim conn As New Odbc.OdbcConnection
conn.ConnectionString = "PWD=;SourceType=DBF;DSN=Visual FoxPro Tables;" &
_
"Collate=Machine;BackgroundFetch=Yes;Exclusive=No;" & _
"SourceDB=" & DbSource & ";" & _
"UID="
Dim strSelect As String = "Select * FROM " & "[" & DbName & "]"
Dim cmd As New OdbcCommand(strSelect, conn)
Dim dr As OdbcDataReader
conn.Open()
dr = cmd.ExecuteReader()
While (dr.Read())
cmbTo.Items.Add(dr.GetString(0))
End While
dr.Close()
conn.Close()
Hi!
Are there any possibilities to open and process an DBase / Visual
FoxPro Table ?