transfertext with extra bit

[ppete]

Hello Boffins,

Can you help?

I have a database which exports a query with the transfertext method:

DoCmd.TransferText acExportDelim, Xspec, "qry" & myarray(X), _
strFolderName & "\" & myarray(X) & ".csv"

and it comes out like this:

"1403","731210",-560.00
"1403","731880",-150.00
"1403","771100",45000.00

I have 2 problems:

1) I need to add a few lines to each of my exported csv files
2) I need to lose the qoutes (")

so it comes out like this:

bud_02hb,,
,,0202

1403,731210,-560
1403,731880,-150
1403,771100,45000

In the export specs i've set the text qualifier to none so I'm a bit puzzled as to why the quotes are still appearing.

Many thanks for you're help,

P

 

[ppete]

Doh!

I figured out number 2)

I was trying to export a number of queries and one of the Fields (column headings) was different in each. I set up the export specs based on the first one so the rest didnae work.

As the field names didn't need to be different I just changed my queries giving column three the same name in each and set up my export specifications again.

If anyboody has an ideas on how to add a couple of lines whilst outputting a csv using Transfertext it would be much appreciated. In the meantime I'm looking into doing it in excel.



P