docmd.outputto

[GShen]

When using the format:
DoCmd.OutputTo acOutputStoredProcedure, "spname", acFormatTXT, pathandfilename, False ...... how do you stop the heading from appearing? I just want he raw data. Also, when I use txt, it is chopping my output and putting dashes on top, below and on the sides. See below for problem output:
----------------------
| tblepoftp_Data |
----------------------
| ISA*00* |
----------------------
| GS*OG*1111111111*6 |
----------------------

I can't find anyway to suppress this or just give me the data. I can't use a table because I don't want the key. I just want the data field.

THanks

Remember when... everything worked and there was a reason for it?

 

[dilettante]

Try forum707

Or forum705

This one is really for classic VB (3, 4, 5, 6) issues and not VBA or MS Access.

 

[ChrisHirst]

I'm sure the OP will get it right one day

thread222-1669783

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum