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

 

[Pat Hartman]

Export the table or query ONCE manually. Going through the wizard allows you to create an export spec where you can specify that you want to include column headings and you want the file to be tab delimited. Name and save the export spec. You'll need to press the advanced button to get to this option. Once you have created the export spec, you can use the TransferText Method/Action and refer to the export spec to use the format options that you selected and saved when you exported manually.

 

[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

 

[Pat Hartman]

READ MY ANSWER!