Best driver for dBase files.

Question

Does anyone know which driver I need to use to open a dbase file that does NOT have an extention of ".dbf"?

I have a folder full of dbase files that are named 1.env,1.pha,1.btr, etc... These are all dbase files and I can open them fine using oleDB driver, but I have to rename each one to ".dbf" first and since they have the same filename "1" for instance I can only rename one at a time then I have to name it back to what it was before I can rename and open the next one.

So is there any driver out there that can open and read a dbase file that may have a different extention than ".dbf"?

Thanks!

Arc · Answer

Hrmm I found this article on the Microsoft website about How to Open dBASE Table with Nonstandard File Extension It suggests using a # sign insted of the normal . for the file extension. Such as 123#ENV however I am still getting the same error using the # sign. The code in this article was made using VB3.0 which I know nothing about but maybe somone here does and can give me some insight into how to get this working. Here is the article. http://support.microsoft.com/kb/101742 Thanks for the help!

Arc · Answer

That is the code I am already using...well I am using dBase IV but I also tried it with dBase III and I get the same result. If the file is named 1.env it says it cannot be found..if it is named 1.dbf it opens just fine.... How do I open a dbf file that has an extension other than .dbf Thanks!

Munir Shaikh · Answer

Hi You can try using following provider connection = New OleDbConnection (Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\capitaltest\data;Extended Properties=dBase III) connection. Open () Thanks & Regards >>Munnamax