VB6 ADODB Connection to dBase III

[MogrDannson]

Can anyone tell me what the ADODB connection string in VB6 for a dBase III file might be?

I am completely unfamiliar with dBase and I want to use the connection to create a recordset which I can read from. Something like:

rstdBase.Open "SELECT * FROM ____", cnndBase, adOpenForwardOnly

Are there separate tables in dBase files the way there are in Access files? If there are how can I get a list of them programatically?

 

[113366]

Let's suppose the dbase III file you want to connect is located in c:\123 and the file name is abc.dbf.

The coding would be as the following

cnndBase.open "Provider= _____;Data Source=c:\123;Extended properties=dBase III"

rstdBase.Open "SELECT * FROM abc", cnndBase, adOpenForwardOnly