Access 97 : export to text file

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Not sure exactly what you are after but this VBA
strTemp = "Hello" & vbCrLf & vbCrLf & "World"
msgbox strTemp will give
Hello

World
 
Back
Top