I have this code that works fine:
DoCmd.TransferText (acExportDelim), "isight2", "qry_main_output_single", Me.FileNamePath & prov & ".txt"
When I try and change the last part to ".dat" I get a Database or Object is Read Only error. I would really like the file to have a .dat instead of .txt. Does anyone know a work around or know if my code is bunk?