You may configure an ODBC Data Source to your MSAccess "file" and use the %SQLGatewayConnection class.
https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls... When I had to use it around 2012 was looking like this:
set dsn="<yourODBCSource>"
set conn=##class(%SQLGatewayConnection).%New()
set sc=conn.Connect(dsn,"","",0)
set res=##class(%ResultSet).%New("%DynamicQueryGW:SQLGW")
set sc=res.Prepare("SELECT * FROM yourAccessTable",,conn)
set sc=res.Execute()
while res.Next() {
write !;res.Get("yourColumn")
}
Certifications & Credly badges:
Kai has no Certifications & Credly badges yet.
Global Masters badges:
Kai has no Global Masters badges yet.
Followers:
Kai has no followers yet.
Following:
Kai has not followed anybody yet.
For me some good reasons could be performance (reading & writing internal storage without conversions), the interoperability with other programming languages where identifiers are case sensitive (e.g. C, C++, Java, C#, Python etc.) and that most unix based file systems are case sensitive too.