Topic: How to get all the table names of an ACCESS database:. Aoto888 (asdfasdf) credit value: 100 Quantity forum: .NET ASP.NET technology issues Points: 100 Replies: 6 Time: 2004-11-02 20:35 : 10 How to get all the table names in an Access database.???
Reply to: saucer (thinking) () Reputation: 326 2004-11-02 22:28:00 Score: 0 you can use a query like
Select msysObjects.name
From msysobjects
WHERE (([Name], 4) <> "msys") and (msysObjects.type) = 1))
Order by msysObjects.name;
Or Use Oledbconnection's Getoledbschematable Method, See
How to retrial schema information by using getoledbschematable and visual c # .net
http://support.microsoft.com/kb/309681/EN-US/
