Copying Table Structure to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings,
Is there anyway to copy the table structure of an Access table and save
it in Excel format? The only thing I have been able to do thus far is save
the table data to Excel, but not the table structure itself. Any suggestions?

Thanks in advance!
 
Hi Sherwood,

Excel doesn't have a concept of table structure, or field types,
indexes, constraints and other features of database tables, so it's not
really possible to export the structure of a table. I suppose you could
create a query on your table that returns no records (the SQL view would
be
SELECT * FROM MyTable WHERE FALSE;
) and then export the query. This should give you a blank worksheet
with, optionally, the field names across the top.
 
Sherwood said:
Greetings,
Is there anyway to copy the table structure of an Access table and save
it in Excel format? The only thing I have been able to do thus far is
save
the table data to Excel, but not the table structure itself. Any
suggestions?

Thanks in advance!
Click to expand...

Sherwood,

The Access Documenter utility (Tools->Analyze->Documenter) can create a
table structure report of your database table(s). When you see the report on
your screen you have the option to save it to Excel.(File->Output
To->Microsoft Excel).

Does that helps?
 
Back
Top