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?

 

[ChrisHirst]

Think you may want forum707 or forum705

Chris.

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

 

[GShen]

Thanks Chris,
This is the 3rd forum I posted this in. THe only reponses I have gotten so far are to post to another forum, like yours. I will try it now.
Gary

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