I have seen multiple posts but they are all too complicated for my access skills. Is there simple utility where I can run it, select a table and get a csv or excel file of the structure
I have seen multiple posts but they are all too complicated for my access skills. Is there simple utility where I can run it, select a table and get a csv or excel file of the structure
Ooops, after Arvil post, just re-read OP and realize misunderstood question.
Access has DatabaseDocumenter utility on ribbon. However, this will only output to print and can be very, very long document. It will include every object.
Last edited by June7; 05-16-2022 at 12:41 PM.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
It looks like OP wants to get table structure, not copy of table - i.e. field names, field types, field widths, number of decimals, etc. In FoxPro you could query the table for this info, but I haven't found any way for this in Access.
I misread the OP's requirements as well
You can easily loop through the tables and obtain the field names, datatypes & sizes
For example, see Microsoft Access tips: TableInfo() function (allenbrowne.com)
That code could be modified to save the info to a table which could be exported to Excel
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Yep, my faulty memory. Pick objects you want report on.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.