Help: batch method to get .MDB table names ???

[Gordon Keeler]

Hi all. I'm trying to develop an automated method
of converting Access (97 or 2000) databases to SAS
using DBMSCopy. I've discovered that there is not a rigid
standard set to control the naming and number of
tables in each database.

Is there a batch method or utility that can extract the
table names from an Access database ???

Thanks for your help.......Gordon

---------------------------
Gordon Keeler, statistician
Dept. of Psychiatry
Duke University Med Center
gk*****@psych.duhs.duke.edu
---------------------------

[Pieter Linden]

Gordon Keeler <gk*****@psych.duhs.duke.edu> wrote in message news:<3F**************@psych.duhs.duke.edu>...

Hi all. I'm trying to develop an automated method
of converting Access (97 or 2000) databases to SAS
using DBMSCopy. I've discovered that there is not a rigid
standard set to control the naming and number of
tables in each database.

Is there a batch method or utility that can extract the
table names from an Access database ???

Thanks for your help.......Gordon

---------------------------
Gordon Keeler, statistician
Dept. of Psychiatry
Duke University Med Center
gk*****@psych.duhs.duke.edu
---------------------------

you could walk the tabledefs collection with DAO and output the result
to a text file or something...

dim db as dao.database
dim tdf as dao.tabledef

set db=dbengine(0)(0)
for each tdf in db.Tabledefs
debug.print tdf.name
next tdf

set tdf=nothing
set db=nothing