Unanswered: problems formatting my text file generated from using OutputTo method
I'm having trouble in Access 2000 formatting the text file generated from this code:
Private Sub Form_Dirty(Cancel As Integer)
DoCmd.OutputTo acOutputForm, "frmTest", acFormatTXT, "test.txt"
I need the text file to be comma delimited WITHOUT the field names as the first row. I need only the data in the recordset.
Please help! Every time it exports I get the field names as the first row and weird borders around each piece of data. I only want commas between the fields and if there are null values I need to see "" instead of " ".
Your problem is very similar to one i had with importation from a text file, i wanted to add data to a table, from a text file and just give me the error "Field F1 doesn't exist....", or something with field F1. Well the problem was resolved, because i do not set the format of importation, for using it in code. Try to see that question in Knowledge Base, i think that might be helpfull.