CODEWITHSUNDEEP
ms-accessvbams-access-2007filesystemobject
user793468
user793468

Reputation: 4976

writing a query output to text file using FileSystemObject

Is there a way to write a query output to a text file using FileSystemObject?

Upvotes: 0

Views: 4285

Answers (1)

managedheap84
managedheap84

Reputation: 851

What's the format of the query results? you may be able to do something like this if it's a simple string, or you may have to extract the bits that you need.

Here's the code to write a string to a text file using the filesystemobject:

Const fsoForAppend = 8

Dim objFSO
Dim queryResult

queryResult = 'OMG no results'

Set objFSO = Server.CreateObject("Scripting.FileSystemObject")

'Open the text file
Dim objTextStream
Set objTextStream = objFSO.OpenTextFile("C:\path\to\logfile.txt", fsoForAppend)

'Write the results to the textfile
objTextStream.WriteLine queryResult

'Close the file and clean up
objTextStream.Close
Set objTextStream = Nothing
Set objFSO = Nothing

Upvotes: 1

Related Questions