Exporting Variable Text from Access

Question

I would like to have Access VBA create a file called "c:\mystuff\AccessOutput.txt" using the ready-to-go text in the string variable called "Text2Export".

Of course, if there is already a file with that name, I'd like this file to replace the old one.

This is just text going into a plain ASCII "txt" file.

How is that done?

Answer 1

Dim intFile As Integer

  intFile = FreeFile()

  Open "C:\mystuff\AccessOutput.txt" For Output As #intFile

  Print #intFile, Text2Export

  Close #intFile