Get rid of line space text file from Ms Access

  • Thread starter Thread starter ngaisteve1
  • Start date Start date
N

ngaisteve1

I did a report in Ms Access 97 and when I export it as text file, som
line got a line space and some doesn't. Example,

<got line space>
CompanyName AIRVAC PTE LTD

Address No. 4, Loyang Street, Loyang Industrial Postcode
508839

<no line space - should be like that>
CompanyName AIRVAC PTE LTD
Address No. 4, Loyang Street, Loyang Industrial Postcode
50883
 
That happens when you export a report to a text file.

Could you use TransferText to export the report's query instead?
 
Back
Top