DBF to Access help

[themaj]

I have a set of dbf tables from one app that I need to manipulate in VB6 and feed into a Access MDB. can anyone tell me the best way to do this within VB6. I don't want to manually convert the DBF files.
In essense I need to Read the DBF table, process information and finally, populate MDB.

If I could just convert the DBF table into MDB, that would be my first preference.

Any and all help would be appreciated.

 

[Golom]

The simplest way is to just link the dBase table directly into Access and then treat it as an Access table in your code. You can then issue SQL commands submitted to JET to do whatever you need to do.

Alternatively you can open the dBase file in VB with

Dim conn                        As New ADODB.Connection
Dim rs                          As New ADODB.Recordset
Dim LPath                       As String
Dim File                        As String
    
LPath = "C:\myPath\"
File = "SomeFile.dbf"

conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
          "Data Source=" & LPath & ";Extended Properties=dBASE IV;" & _
          "User ID=;Password="

rs.CursorLocation = adUseClient
rs.CursorType = adOpenKeyset
rs.Open File, conn

And then process "rs" to do whatever you need to do.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]