469,282 Members | 1,843 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

command line utility for displaying table names of MS Access database

Can anyone point me to an existing utility or code template to write a
utility? I want a command line utility, passing in the MDB filename,
producing a file (text or whatever) of tablenames and fieldnames.

Feb 10 '07 #1
1 1446
On 10 Feb 2007 12:57:39 -0800, st**************@va.gov wrote:

If I really wanted a command-line utility, I might consider creating a
VBScript file (*.vbs by default) and running that using cscript.exe:
cscript c:\test.vbs -i:c:\test.mdb -o:c:\test.txt
I think the VBScript file can handle commandline arguments. From that
point, I would use DAO or ADOX to get the table information. Those
objects would be created using CreateObject. The FileSystemObject can
be used to create the output file.

-Tom.

>Can anyone point me to an existing utility or code template to write a
utility? I want a command line utility, passing in the MDB filename,
producing a file (text or whatever) of tablenames and fieldnames.
Feb 10 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.