go to post Kai Fischer · Mar 23, 2022 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") }