how to export Access MDB file to ASCII text format ?

English Programming/Scripting
#1

Hi,

I have opensuse 11 installed. I would like to know if from this OS, there’s a way to export a Table from Microsoft Access MDB file, into CSV or ASCII text format? But I need it to run from the shell, because I would like to put this command into a script to run automatically.

For example, something like this:

mdbtools <filename.mdb> <table name> <output_filename.txt>

#2

Try to examine some of the perl-scripts on CPAN. I found several perl-scripts that could manipulate excel-file to/from csv/txt.

CPAN

Jan