Get rid of line space text file from Ms Access

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
 
A

Allen Browne

That happens when you export a report to a text file.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

merging fields from Outlook Contacts 2
Word 2003 Mail merging blank field previous record 0
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Removing Spaces from Email 0
Bad character spacing in linked Word file 1
Problem with line spacing and Text Field "Growing" 0
Import Text from File - Line Spacing 2
["\r\n" new line command in CSV file] 1

Top