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. I tried using docmd.transfer but the problem there is that I can't get it to work with a stored procedure. I can't use the table because I do not want the key and it HAS to be in the sequence I write it to the table. If you tell me it will always write out in the sequence I write to the table, then I can go back to the transfer text. I tried doing this query thing but it looks like that is an MDB thing, not ADP.

If I confused anyone, let know I will try and rewrite this.

THanks Gary

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

 

[UnsolvedCoding]

Does your stored procedure specify the header row?

 

[GShen]

Not sure what you are taling about. Can you be more specific? Have never heard of an option like that. Also, what about the bars surrounding the field on top and the sides?

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