Hello...
Can someone tell me how one would go about copying the table list within
the "Tables" tab in Access and be able to paste those table names into Excel.
I would think this would be possible. I want to create an Excel file that
lists out all of the tables, queries, etc that are in the database. Thanks
in advance.

What will having a "list of table names" in Excel allow you to do?

Have you looked into the Tools | Analyze | Documenter function that will
generate printed output of these kinds of things?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"deeds" <(E-Mail Removed)> wrote in message
news:20799F55-4EA8-4EDD-BF9C-(E-Mail Removed)...
> Hello...
> Can someone tell me how one would go about copying the table list within
> the "Tables" tab in Access and be able to paste those table names into
> Excel.
> I would think this would be possible. I want to create an Excel file that
> lists out all of the tables, queries, etc that are in the database.
> Thanks
> in advance.

Thanks...that gives good info, however, all I want is a list of all tables, a
list of all queries...then I can show graphically which queries make which
tables, etc.... Let me know if you have another option. Thanks.

"Jeff Boyce" wrote:

> What will having a "list of table names" in Excel allow you to do?
>
> Have you looked into the Tools | Analyze | Documenter function that will
> generate printed output of these kinds of things?
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "deeds" <(E-Mail Removed)> wrote in message
> news:20799F55-4EA8-4EDD-BF9C-(E-Mail Removed)...
> > Hello...
> > Can someone tell me how one would go about copying the table list within
> > the "Tables" tab in Access and be able to paste those table names into
> > Excel.
> > I would think this would be possible. I want to create an Excel file that
> > lists out all of the tables, queries, etc that are in the database.
> > Thanks
> > in advance.
>
>
>

Create a new query:

SELECT MSysObjects.Name, MSysObjects.Type
FROM MSysObjects;

You can set criteria on the Type field to return only local tables, linked
tables, queries, etc.
Then export it to Excel.
--

AG
Email: discussATadhdataDOTcom
"deeds" <(E-Mail Removed)> wrote in message
news:20799F55-4EA8-4EDD-BF9C-(E-Mail Removed)...
> Hello...
> Can someone tell me how one would go about copying the table list within
> the "Tables" tab in Access and be able to paste those table names into
> Excel.
> I would think this would be possible. I want to create an Excel file that
> lists out all of the tables, queries, etc that are in the database.
> Thanks
> in advance.

Thanks! Works good. Now to take it another step. It would be nice to be
able to identify between make table, select, append etc.. queries. Let me
know if that is possible....thanks again!

"AG" wrote:

> Create a new query:
>
> SELECT MSysObjects.Name, MSysObjects.Type
> FROM MSysObjects;
>
> You can set criteria on the Type field to return only local tables, linked
> tables, queries, etc.
> Then export it to Excel.
> --
>
> AG
> Email: discussATadhdataDOTcom
> "deeds" <(E-Mail Removed)> wrote in message
> news:20799F55-4EA8-4EDD-BF9C-(E-Mail Removed)...
> > Hello...
> > Can someone tell me how one would go about copying the table list within
> > the "Tables" tab in Access and be able to paste those table names into
> > Excel.
> > I would think this would be possible. I want to create an Excel file that
> > lists out all of the tables, queries, etc that are in the database.
> > Thanks
> > in advance.
>
>
>

I think this will give you what you are looking for.
http://www.sqlquery.com/Microsoft_Ac...l_queries.html

--

AG
Email: discussATadhdataDOTcom
"deeds" <(E-Mail Removed)> wrote in message
news:49CEAE97-6358-4CB0-BE92-(E-Mail Removed)...
> Thanks! Works good. Now to take it another step. It would be nice to be
> able to identify between make table, select, append etc.. queries. Let me
> know if that is possible....thanks again!
>
> "AG" wrote:
>
>> Create a new query:
>>
>> SELECT MSysObjects.Name, MSysObjects.Type
>> FROM MSysObjects;
>>
>> You can set criteria on the Type field to return only local tables,
>> linked
>> tables, queries, etc.
>> Then export it to Excel.
>> --
>>
>> AG
>> Email: discussATadhdataDOTcom
>> "deeds" <(E-Mail Removed)> wrote in message
>> news:20799F55-4EA8-4EDD-BF9C-(E-Mail Removed)...
>> > Hello...
>> > Can someone tell me how one would go about copying the table list
>> > within
>> > the "Tables" tab in Access and be able to paste those table names into
>> > Excel.
>> > I would think this would be possible. I want to create an Excel file
>> > that
>> > lists out all of the tables, queries, etc that are in the database.
>> > Thanks
>> > in advance.
>>
>>
>>