export to .csv file

[slyvsspy]

When I export out of Access, it doesn't export it the way I have to have it to import it into my other program. Here is the way it looks when Access exports it.

------------------------------------------------------------------------
| NCSSTATUS | ATDOOR | HOWMANY |
------------------------------------------------------------------------
| Y | Y | 1 |

Here is the way I need it to look.

| NCSSTATUS | ATDOOR | HOWMANY |
| Y | Y | 1 |


I need it to export without the --------------. Does anyone know how to do this. You also have to keep in mind that I am running this export off of a command button on a form.

 

[pcs]

what is the code on your command button?

are you using OutputTo or TransferText?

do you have an export spec.?

al

 

[slyvsspy]

macro

I am running a macro with my command button. The macro uses the "outputTo" function with the ms-dos .txt format. Would it be better to just use VBA. If so , how do I go about doing that.??

Thanks

 

[slyvsspy]

transfer text

I tried the transfer text and it worked perfectly except for one thing. How do I get the "field names" to be the first row of the newly created .txt file?

Thanks