How to export/save a Query or Report as Text File?

[Mel_3]

With Access 2007 on PC XP Pro.



We need to run a query and then create a custom text file with the results.

We also want Access to add certain text to the text file before each data field or each new line of data.

Our thoughts were to run the query and report...
...and put the custom text into the report as custom field names or whatever.

The question:

1 - Is this the correct approach?
2 - If not how? (example/sample/tutorial if you can
3 - Can you "save" a report as a text file?

Thanks for any help.

[ssanfu]

The question:

1 - Is this the correct approach?

2 - If not how? (example/sample/tutorial if you can
3 - Can you "save" a report as a text file?

Thanks for any help.

1) Hard to say.. haven't seen an example of what you want the text file to look like.

2) I create text files and write to them - I add a header, then create text strings and write them to the text files. My text files are errors and info about what has changed. Here is an example....

    Dim EF As Integer  'errors file


    EF = FreeFile
    str = DLookup("LastFileImported", "tblImportFileName")
    pos_slash = InStrRev(str, "\")
    pos_dot = InStrRev(str, ".")
    FileToWrite = Mid(str, pos_slash + 1, pos_dot - pos_slash)
    FileToWrite = CurrentProject.Path & "\ERRORS_" & FileToWrite & "_ImportEmp" & ".txt"

    Open FileToWrite For Output As #EF
    'print header text
    Print #EF, "EmpID, SSN, LName, FName, Old Fringe Rate, New Fringe Rate, Change Date"


    'static text
    Print #EF, "ERROR- Invalid SSN "
    ' error data
    Print #EF, vEID & ", " & vSSN & ", " & vLast & ", " & vFirst
    ' print blank line
    Print #EF,


    ' close and save text file
    Close #EF

3) You can (in A2K3) open the report, then export the report as a txt/csv/tab/asc file. (FILE/ EXPORT)