How to read access files?

Banksy · June 23, 2022, 1:23am

Hi Everybody，

I want read access files , but “DB Table Selector” node not work.
Do you know how to solve this problem?
Thanks in advance.

mlauber71 · June 23, 2022, 6:06am

@Banksy I assume you can access the data in the original file?

Can you check if it might be a View accessing data outside the file?

Also could you provide us maybe with a log in debug mode and update the metadata in the table selector on the left side.

Banksy · June 23, 2022, 6:56am

Hi @mlauber71 ,

The access file can view data from outside and KNIME log please following image, thanks.

mlauber71 · June 23, 2022, 8:42am

@Banksy I do not think the driver can follow the external links in an Access file.

ScottF · June 23, 2022, 8:55pm

@mlauber71 is correct here. This is unfortunately a limitation of the UCanAccess driver and linked files.

Banksy · June 24, 2022, 1:53am

Hi @mlauber71 ,

I’m so sorry, I don’t get it. Why can’t the driver follow the external links in an Access file? And how to edit the KNIME workflow can be use, thanks.

mlauber71 · June 24, 2022, 4:50am

I think the only way currently would be to access the linked files separately from KNIME and recreate the query/table.

I don’t know. You might post that question in the forum of the UCanAccess driver.

https://sourceforge.net/p/ucanaccess/discussion/help/thread/85e8e178/

system · September 22, 2022, 4:51am

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.