BDE is the Borland Database Engine. They are dBase IV. You should be able to access them via ODBC.
>I have a set of tables from an unknown database that I need to import into VFP 7. These tables ship with BDE as part of their application and the file extensions are .DBF, .DBT, and .MDX. My immediate assumption was dBase IV, but USE generates a “not a table” message, regardless of SET COMPATIBLE. "SELECT * FROM MysteryTable" also generates “not a table.” "IMPORT FROM MysteryTable TYPE PDOX" (hey, I was desperate) gets me a “Paradox file format is invalid.”
>
>My mama didn’t raise no dummy so I went to ODBC.
>
>nSQLHandle=SQLSTRINGCONNECT("Driver=Microsoft dBase Driver (*.dbf)" + CHR(0) + "DBQ=" + cSrc)
>gets me a connection handle, where cSrc is the data path, but
>
>lnSuccess = SQLEXEC(nSQLHandle, "SELECT * FROM MysteryTable", 'MyCursor')
>
>returns -1 for dBase 3, 4, and 5. No joy in Mudville.
>
>So I fire up Access 2003 and do the File>Import thing with files of type dBase IV, and sure enough, it pulls them right in, no questions asked. So now I could bring them all into Access then from there into VFP, but I’ve got 19 sets of data, and each set has over 300 data files, and I’m too old to deal with all that before I die.
>
>Anybody have any better ideas?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer