Exporting Access Database to Text File Format - Can be automated?

[Guest]

Hi,
I know we can export access database to a text file,
But can it be automated ? ( through a batch job instead of manual?)

Manual Process
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Click on the File menu, click Export .
In the Save As Type list, click Text Files (*.txt, *.csv, *.tab, *.asc), and
then click Save .
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Regards,
Ron

 

[Allen Browne]

See help on
TransferText

 

[Stefan Menner]

Hi,
I know we can export access database to a text file,
But can it be automated ? ( through a batch job instead of manual?)

I've writen a command line tool (shareware) for sending SQL-Statements to
JET databases.
You can SELECT, ALTER, UPDATE etc as well as export to csv, watch table
structure etc etc.
This works even if access is not installed - because JET is installed by
default in Windows 2000 and up.
Contact me if you are interested.

Stefan