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

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

Tom van Stiphout

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top