How can I access dbase?

Hi,

I want to access dbase database, can anyone help?

I try :

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Data Source=D:\Account\;Extended Properties=DBASE III;',
TRANS.DBF)

and I got the following message :

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not find installable ISAM.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

Thanks and I really appreciate any help
joe

make sure you have the proper MDAC installed:

http://msdn.microsoft.com/data/ref/mdac/downloads/

|||

Hi Dman1

How can I check if I have the correct MDAC installed, and what will installing this do?

Thanks

|||

MDAC is Microsoft Data Access Components and it is a package of software files that provides connectivity (communication to and from ) odbc compliant data sources. As far as checking the installation see the following:

MDAC Utility: Component Checker

http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en