469,356 Members | 2,641 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,356 developers. It's quick & easy.

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

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

Nov 12 '05 #1
1 1363
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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

28 posts views Thread by stu_gots | last post: by
4 posts views Thread by Norman Fritag | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.