Export to Text File Exporting Blank Lines

[NMiller007]

I am trying to export a report as a text file, which we will send off for import. I am getting the data to come out how I want it using an OutputTo, but there are blank lines in the text file. For example:

0000001 01012007 500000
0000002 01012007 5000001

0000003 01022007 5005555
0000004 04012007 99999

There is a blank line at the top. One export I did had three lines then a blank space and another only did two before a blank.

Any ideas why this is happening? Can I remove it? Is there a better way yo export the text file? Can I take the query that generates this data and write to the text file line by line?

Thanks!

 

[NMiller007]

Solved!

I found a FAQ on this site detailing how to write the text file using a VBA loop.