Reading Multi Database Table Properties on Local Server 1

[ApxMnk]

Greetings, fellow developers....

I am trying to programmatically loop through a series of folders/sub-folders on a network server, opening any/all *.mdbs, finding all Tables and writing the Table name and Field properties/datatype to an MS Excel spreadsheet. Any thoughts at all?

 

[fredericofonseca]

yes.

Look at the filesystem object to loop through your folders.

Look at using ADOX or ADO for opening and enumerating that tables/fields from the .mdbs

Look at the Excel object for updating the spreadsheet, or look as using ADO for it.


All the above should keep you going for a while, as there are plenty of examples for all the above on these forums.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com