By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,687 Members | 1,989 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,687 IT Pros & Developers. It's quick & easy.

command line utility for displaying table names of MS Access database

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.