S
Sam
I am using the code below. The files are exporting as comma
delimited. Is there a way for them to export as tab delimited?
For Each qdf In db.QueryDefs
strqryName = qdf.Name
If strqryName Like "exp_*" Then
SysCmd acSysCmdSetStatus, "Exporting " & strqryName &
"..."
DoCmd.TransferText acExportDelim, , strqryName, _
"C:\Documents and Settings\griffis1\My Documents\MASUNL\" _
& Mid(strqryName, 5) & ".txt", True
End If
Next qdf
Thanks for you assistance!!!
delimited. Is there a way for them to export as tab delimited?
For Each qdf In db.QueryDefs
strqryName = qdf.Name
If strqryName Like "exp_*" Then
SysCmd acSysCmdSetStatus, "Exporting " & strqryName &
"..."
DoCmd.TransferText acExportDelim, , strqryName, _
"C:\Documents and Settings\griffis1\My Documents\MASUNL\" _
& Mid(strqryName, 5) & ".txt", True
End If
Next qdf
Thanks for you assistance!!!