How connect to dBase from VB 6.0?

[VNDN]

Hello all,
Can you show me how to connect to dBase. Thank you much in advance. CVL

 

[Spellman]

What kind of data access are you using to try to connect Mark

The key to immortality is to make a big impression in this life!!

 

[VNDN]

Mark,
ADO

 

[CasperTFG]

Here are 2 samples... for DAO and ADO.

DAO

Sub DAOOpenISAMDatabase()

Dim db As DAO.Database

Set db = DBEngine.OpenDatabase(".\Sales.xls", _
False, False, "DBASE Extended Property;&quot

db.Close

End Sub
ADO

Sub ADOOpenISAMDatabase()

Dim cnn As New ADODB.Connection

cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=.\Sales.xls" & _
";Extended Properties=DBASE Extended Property;"

cnn.Close

End Sub

These are the Extended properties for DBase
dBASE III
dBASE IV
dBASE 5
Craig, mailto:sander@cogeco.ca

In the computer industry, there are three kinds of lies:
lies, damn lies, and benchmarks.

 

[CasperTFG]

Oh I guess I should include where I stole this from...

http://msdn.microsoft.com/library/d...ry/en-us/dndao/html/daotoadoupdate_topic4.asp

And there you have it Craig, mailto:sander@cogeco.ca

In the computer industry, there are three kinds of lies:
lies, damn lies, and benchmarks.

 

[VNDN]

Craigsander,
I have an error("Could not find an installable ISAM driver&quot when I used your code. Thanks CVL

 

[Spellman]

Check your machine for MSXBSE35.dll. It needs this if it's going to use the XBAse drivers. Mark

The key to immortality is to make a big impression in this life!!