You can import data file using ODBC. It might be necessary to have MS Access installed, but the drivers are often pre-installed even if MS Access is not present.

In order to set up the database, you should go to your Windows Control Panel > Administrative Tools > Data Sources (ODBC) and then click Add. Choose Microsoft Access Driver and then click Finish.

The ODBC Microsoft Access Setup dialog opens, as shown in the following image.

Provide the name of the source in the Data Source Name field.

Provide the path to the database by clicking Select.

Then go to DQS, right-click Databases > New > Database Connection. Choose ODBC as the driver type and type the DSN as the connection name:

You can also use the By URL option and type the following to the Connection string field:

jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=D:\Support\RBI\test.accdb

DBQ is the path to the MS Access file (for example, D:/Support/RBI/test.accdb).

Ensure to Test Connection to see if the connection was configured properly.

Note: The ODBC driver exclusively locks the file, so it cannot be open by any other application.