Exporting database information to Excel

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

Guest

I am working with an extremely large database in an attempt to stremline it.
I would like to export the names of tables, reports, queries etc ... to Excel
with size parameters. All the information except size is available through
the file MSysObjects. Does anyone know what file would contain all the
pertinent information including the size of each of the database objects and
is it exportable to Excel? The version of Access is 2003.

Thanks!
 
Unlike some databases, such as Oracle, where things like tablespace sizes are
readily available in tables and views, Access keeps things pretty close to
the vest. AFAIK there isn't a table that you can query which will give you
that information.
 
Back
Top