Automatic Export to txt
Hello!
I try to export my qurey to a tabdelimitered txt file via a button.
When doing this I will not get the header row in the file.
If I do the export manually I can choose to get the header row. If I save the exportspecification the selection of header row will not be included.
Hope you can help me.
Here is the code for the button:
Private Sub Kommandoknapp0_Click()
On Error GoTo Err_Kommandoknapp0_Click
DoCmd.TransferText acExportDelim, "utskick", "Utskick alla", "C:\Documents and Settings\sssmwb\Desktop\Utskick alla.txt"
Exit_Kommandoknapp0_Click:
Exit Sub
Err_Kommandoknapp0_Click:
MsgBox Err.Description
Resume Exit_Kommandoknapp0_Click
End Sub
Hello!
I try to export my qurey to a tabdelimitered txt file via a button.
When doing this I will not get the header row in the file.
If I do the export manually I can choose to get the header row. If I save the exportspecification the selection of header row will not be included.
Hope you can help me.
Here is the code for the button:
Private Sub Kommandoknapp0_Click()
On Error GoTo Err_Kommandoknapp0_Click
DoCmd.TransferText acExportDelim, "utskick", "Utskick alla", "C:\Documents and Settings\sssmwb\Desktop\Utskick alla.txt"
Exit_Kommandoknapp0_Click:
Exit Sub
Err_Kommandoknapp0_Click:
MsgBox Err.Description
Resume Exit_Kommandoknapp0_Click
End Sub
Last edited:
