Table Fields to New Table

[NigelShaw]

Hey there!

Long time since ive walked these corridors, hope everyone is ok

I have a database with about 50 or so tables. I ran a database documenter so that i can get a list of all fields and it generated 36 pages with roughly 4000 fields. I need to create a new single table with 4 columns (ColumnType is optional) and then add the field names and table name to the new table.

ID - TableName - FieldName - ColumnType

Is there an easy method to accomplish this? the thought of reading through and typing out all of the fields is a little overwhelming...

any help greatly appreciated


Thanks

 

[CJ_London]

loop through the tabledefs collection and insert your new table

 

[Gasman]

I use Google as I would still need help with the code.

https://stackoverflow.com/questions/201282/how-can-i-get-table-names-from-an-ms-access-database

https://software-solutions-online.com/access-vba-get-field-names/

HTH

 

[arnelgp]

run test01 on Module1.
the structure of each table will be saved to allTableStructure table.
see code in Module1.

 

[theDBguy]

Hi. You can also check out this demo.

Get a List of Table Fields

 

[NigelShaw]

run test01 on Module1.
the structure of each table will be saved to allTableStructure table.
see code in Module1.

Works a treat, thank you very much

 

[arnelgp]

you're welcome, back!