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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top