Access 97 : export to text file

G

Guest

The text file will receive accounting records for a third party accounting
package. Each record set contains 2 or more transactions. The third party
package requires a double carriage return to signify the end of each record
set.
Any suggestions how this can be done automatically using VBA.
I was going to use the Connect property method to export but have no idea
how a double carriage return could be generated
I would be grateful for any advice
Ralph
 
G

Guest

Not sure exactly what you are after but this VBA
strTemp = "Hello" & vbCrLf & vbCrLf & "World"
msgbox strTemp will give
Hello

World
 

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

Fixed-Width text file export 1
Text Selection/Manipulation 2
Report Export to Text File 1
Report Export to Text File 8
Text file with One line Spacing 8
Carriage returns in exported text file 4
MS ACCESS REPORT EXPORT TO TEXT FILE 2
How to Export VBA Code to a text file 2

Top