export to text: remove blank lines/empty rows

[anski]

i am exporting a union query to a text file. i expect the cursor to be at the end of my data. instead, when i open the text file, the cursor is 2 rows away from the last row (with data). the export creates blank rows. the blank rows cause an error when i upload the text file to another program.

what do i use to remove the blank lines/empty rows?

 

[Ranman256]

Make another query that uses the union query,
Remove blanks in this query.
Export this.

 

[anski]

^the query does not have blank rows (or even blank fields).

 

[JHB]

Could you post an example database that have the problem you describe?

 

[anski]

SOLVED: Re: export to text: remove blank lines/empty rows

the union query does not have any blank rows. i use the transfertext command to export to csv or text. i found something that works for me. this deletes the last blank row (access creates 2 blank rows) but still leaves one blank row which is acceptable to the program that i upload the exported file to.

if Right(sTemp, 2) = Chr(13) & Chr(10) Then
sTemp = Left(sTemp, Len(sTemp) - 2)