Exporting an access table to a txt file (1 Viewer)

[littlej]

I would like to be able to automate exporting a table into a text file. Does anyone know the VB code for doing this process? I know I could do a "File" ,"Export" but I don't want to do that everytime. I have also tried the "output to" command and no luck.

 

[littlej]

Problem fixed.

Problem fixed. Output stmt worked..