Extract table information from MS Access databse
Hi Everyone,
I have a MDB file which contains approximately 100 tables. I need to list all the tables along with information about fields (including name, type and size). Is there some tool for thsi purpose? or can I write some small application myself for this?
I tried the Tools->Analyze->Documenter, but it just hung up my system and I could not do anything at all for a long time. So I ended the task.
Can anybody tell me some tool/trick to do this work faster....
please help....
Manish
Re: Extract table information from MS Access databse
It is fairly easy to write an application to do this in VB 6.0 or .Net (like C# or VB.Net).
A lot of tools can extract the information for you as well, like Visio, Enterprise Architect from Sparx Systems, and surely a lot of DB tools.