how to export MDB file from the command line in Windows?

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I can export Tables from Microsoft Access MDB files using the export
option, but my users have many tables to export, and it's cumbersome
for them to do so.

Is it possible through Windows in the command line, to output an MDB
file to a text file? If it's possible, then, I can put that command
in a batch program and allow the users to easily do the export for
many MDB files.

For example, at the command line:

MDBTOOLS <filename.mdb> <outputfile.txt>
 
On Sun, 19 Jul 2009 12:09:39 -0700 (PDT), Michelle

It's not trivial, but you can indeed write a VBScript file and use
CreateObject to create an Access.Application object, which you can
then use to export the tables. Such script files can be run from the
command line using cscript.exe.

-Tom.
Microsoft Access MVP
 
Back
Top