Read some specific tables from access DB

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.

Data Investigation

Accepted answers

danilang

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

All comments

Thableaus

Hi @TarunaT

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

Cheers,

danilang

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

TarunaT

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

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235