From VB.NET, I have the code to access a DBase IV table. This works only as long as the table extension is .DBF. We are receiving the files as .STL as far as the extension goes. So, if I have a file name such as SGZYW56V.stl, I cannot have this command to be executed:
SELECT * FROM SGZYW56V
But, if I rename the file to SGZYW56V.dbf, this will work.
I am using the Microsoft.Jet.OLEDB.4.0 data provider to access it. I would like to know if the only option is to rename the file to SGZYW56V.dbf. We would like to avoid renaming the files. Will it be possible to handle the SQL command with a .STL extension?