Tom, thanks a ton for the help. But there is still a small issue I a
facing with the output.

Everytime the code retrieves the table names, it also retrieves th
following tables as well:

MSysAccessObjects
MSysACEs
MSysObjects
MSysQueries
MSysRelationships

What do I do to avoid displaying these tables as the output?

Please help on this one too.

Peace,

Shivboy
Tom Ogilvy Wrote:
two approaches:

http://tinyurl.com/fpvvr

http://tinyurl.com/p45cj



--
Regards,
Tom Ogilvy

"shivboy" wrote:


I am using VBA in MS Excel to create tables in MS Access and set
relationships between the tables as I have large amounts of related
data. Now in order to do that, I need to know how to list the name
of
the tables and fields in the tables in the database. This would hel
me
to choose tables and further choose fields in those tables to set
relationships between them. How do I do that? Please help.

Peace,

Shivboy


--
shivboy

------------------------------------------------------------------------
shivboy's Profile
http://www.excelforum.com/member.php...o&userid=35137
View this thread
http://www.excelforum.com/showthread...hreadid=551602



--
shivbo
-----------------------------------------------------------------------
shivboy's Profile: http://www.excelforum.com/member.php...fo&userid=3513
View this thread: http://www.excelforum.com/showthread.php?threadid=55160