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

N

Nironto

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
 
S

Stefan Menner

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

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
 
Top