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.
Solved! Go to 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
Thanks @danilang , it showed me the way to do it !