Access 97 : export to text file

S

stewart reid

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
 
D

Dennis

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

World
 
Top