VBA: Getting list of TableName/FieldName

Is it possible to write VBA code to get table name and field name from database?

For example, if I have Sybase database abc, and I would like to list all tables and fields in sheet Output, something like below screenshot.

Is it possible? If yes, how to complete my code?

Thanks.

Please Login or Register  to view this content.

Originally Posted by Zeki Gürsoy

You can access this information by using the "ADOX (Microsoft ADO Ext. 2.8 / 6.0 DDL and Security)" library.
Please search web or MS documents.

Then how should I finish remaining code?

Thanks.

Originally Posted by rorya

You could use a routine like this - just pass it a connection object and a cell to start the output in:

Please Login or Register  to view this content.

Thanks for the code, how can your code be merged into my existing code? I would like to write the result in the sheet "Output"?

Originally Posted by rorya

After adding that code as a separate routine, replace your red line with:

Please Login or Register  to view this content.

for example.

Thanks so much for the code, in general, it works.

I have changed a1 to a2, since I would like to reserve cell A1 and B1 for heading cells "Table Name" & "Column Name".

Highlighted green area is the output from your code, could you please modify your code to make the output looking like the highlighted yellowed area (without empty cells in between)? If not, I can write separate code to delete/shift up cells.

Thanks.

Thanks so much.