Exporting database information to Excel

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!
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble Exporting from database to excel 1
Exporting Data from Access To Excel 10
Exporting data between excel files 1
exporting to excel problems 4
Import data and update changed information 1
Exporting to a template in Excel 1
Import File Information 0
Export Queries and Tables to Excel 1

Top