How to Import Infor Datalake Views/Tables in MS Access

In this article, we will see how to import Infor Datalake Tables and Views in MS Access.

You can refer to this article for detailed steps

However one issue you may face is that Views might not appear when imported into MS Access. To fix this issue, perform the following steps.

  1. Open JDBC Bridge DSN (created as per the previous article link)
  2. Change Tables Metadata Mode setting to IgnoreTypes like below.
  3. Now try to import again, and you will see all Tables and Views in the list dialog box