In (DAO) SQL, I can use ISAM to connect to an Excel sheet to import/export data using expressions like:
SELECT T1.* INTO Temp FROM [Excel 8.0;HDR=YES;IMEX=1;Database=D:\test.xls].[Sheet1$A1:U65536] AS T1
Is there and equivalent way to connect to an MDB/ACCDB file?
(I'm in an app that can run SQL, but doesn't give me direct control over connection strings etc., so it needs to run just from SQL)
I found I can directly access older format MDB files using something like:
SELECT Components.Description FROM `C:\Users\me\Desktop\database.mdb`.Components
But this doesn't work for newer MDBs, where my query complains about the file format.
What I have tried:
Googling, but there is no ISAM for Access databases.