How to copy paste "Design view" from Access to excel?

Question

I go to "Design view" of a given table and just want to copy/paste what I see into an excel sheet.

The solutions I saw suggest "Database Documenter", but if we include "Properties" it exports way too much data. Another method suggests some .mdb files, but examples I see are all 32bit, so I'm a bit stuck..

Have been at it for over an hour and this inability to copy/paste data we see (from a screen that looks a lot like excel) into actual excel sheet is strange to say the least...

Answer 1

1. Goto Ribbon Database Tools

2. Click Database Documenter

3. Select the table

4. Click Options

   a. De_Select all of "Include for table"

   b. Select "Nothing" of "Include for Indexes"

   c. Select "Names, Data Types, and Sizes" of "Include for Fields"

5. OK.

6. Click "Excel" in the Ribbon to Export to Excel.