Convert to Text without the heading and the lines

  • Thread starter Arvin Villodres
  • Start date
A

Arvin Villodres

I'm trying to convert a table to an MD DOS Text format
my code looks like this:

DoCmd.OutputTo acTable, "tblLeaveTrans", "MS-DOSText
(*.txt)", "d:\eb.txt", False, ""

and the output looks like this:
----------------------------------
| TRANSNO | From |
| 114 | 7/7/2003 |
| 115 | 7/4/2003 |
| 116 | 7/5/2003 |
| 117 | 7/3/2003 |

How can I remove the heading and the lines and make my
output look like this:

114000772003
115000742003
116000752003
117000732003

Thanks for the help. I would really appreciate your help.
 
Top