Naming Convention for Text Export

[grumpydadtl]

How can I name a text export using periods in the file name:

ABC.D31.HBCVF.txt.rbd31

as opposed to something like "Export.txt"?

Each time I try, Access changes the text export file name to:

ABC#D31#HBCVF#txt#rbd31

I am using a fixed width text export.

[ADezii]

I don't think that Access will allow you to do that directly, but ironically, you can Rename the Fixed Width Text File immediately after creating it, allowing Periods, as in:

DoCmd.TransferText acExportFixed, "<My Specs>", "Employees", "C:\Test\ABC.D31.HBCVF.txt", True
Name "C:\Test\ABC#D31#HBCVF.txt" As "C:\Test\ABC.D31.HBCVF.txt"

BTW, it is a good idea to leave the .txt Extension at the end of the File.

[grumpydadtl]

That worked perfectly! The file name (and extension) is for an import into a mainframe program. Since I have to overwrite this same file name on each export, is there a command to delete the text file at the start of the routine?

Currently the program halts when it realizes there is already a file named the same as I am trying to change the export file to.

[ADezii]

That worked perfectly! The file name (and extension) is for an import into a mainframe program. Since I have to overwrite this same file name on each export, is there a command to delete the text file at the start of the routine?

Currently the program halts when it realizes there is already a file named the same as I am trying to change the export file to.

Try:

Kill "C:\Test\ABC#D31#HBCVF.txt"