Read some specific tables from access DB

[TarunaT]

Hi,

I have few mdb files with multiple tables in it. However, I wanted to read one specific table "Host" from all the files. I am able to do that, but its throwing me an error wherever that table is not existing. I want to ignore the files which does not have "host" table. How can I do that? Please help.

[Thableaus]

Hi @TarunaT 

Have you tried to use a Directory Tool + Dynamic Input Tool?

Cheers,

[danilang · Accepted solution]

Hi @TarunaT 

Check out this post specifically the solution that mentions to query the MSysObjects table.

SELECT MSysObjects.Name AS table_name
FROM MSysObjects
WHERE (((Left([Name],1))<>"~") 
        AND ((Left([Name],4))<>"MSys") 
        AND ((MSysObjects.Type) In (1,4,6)))
order by MSysObjects.Name 

You can run this against each of the mdbs and if the table name is not in the list, then skip this file

Dan

Dan

[TarunaT]

Thanks @danilang , it showed me the way to do it !