Results 1 to 8 of 8
  1. #1
    Anil Bagga is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Apr 2020
    Posts
    69

    I want a simple solution to copy table structures into. csv or Excel

    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

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    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.

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    Or just right click on the table in the navigation pane, click Export then select Excel or Text file
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  4. #4
    Join Date
    Apr 2017
    Posts
    1,679
    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.

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    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
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  6. #6
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,791
    It will include every object.
    AFAIK, it only includes what you tell it to?
    The output can go into about 6 or more different formats. Here is the minimum for 1 table - no index info, no db or table field properties, no relationships, no permissions, etc.

    Click image for larger version. 

Name:	aDBdocumenter.jpg 
Views:	27 
Size:	28.0 KB 
ID:	47811
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    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.

  8. #8
    Anil Bagga is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Apr 2020
    Posts
    69

    Thank you

    Quote Originally Posted by June7 View Post
    Yep, my faulty memory. Pick objects you want report on.
    Thank you everyone for responding so quickly. I am sure I will be able to find the best fit among the various solutions on offer.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Consolidating Table Structures
    By chemguy120 in forum Database Design
    Replies: 8
    Last Post: 05-16-2018, 02:29 PM
  2. Complex problem, hopefully a simple solution?
    By g4tv4life in forum Queries
    Replies: 1
    Last Post: 03-28-2014, 11:30 AM
  3. Simple stock keeping solution
    By Count Duckula in forum Database Design
    Replies: 5
    Last Post: 06-11-2013, 09:03 AM
  4. Probably a simple solution, but driving me nutz!
    By Bribie4507 in forum Queries
    Replies: 3
    Last Post: 02-22-2013, 07:10 PM
  5. Probably a simple solution, but I am stuck
    By ANC-AB in forum Queries
    Replies: 3
    Last Post: 04-29-2012, 10:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums