Exporting text using tilde as delimiter 1

[Strobeman]

I am trying to export data to a text file with tilde delimiters. Access help says it can be done by creating a Schema.ini file. I have been able to do this for importing a text file and it works just fine but have not managed to be able to create one for the export. The file I am exporting will have a new name every time as well. At the moment it is exporting using the standard comma delimiters using the code below. Any ideas?

txtFile = txtFolder.Value & "\" & txtHEICode & txtAcademicYear & txtFileType & txtFileDate & txtSequenceNumber & txtLocationCode & ".txt"
DoCmd.TransferText acExportDelim, , "SSAC - to SLC Extract Rec", txtFile

 

[mikevh]

Take a look at thread707-530315, where someone was
having a similar problem. I think you'll find this
is what you need.

 

[Strobeman]

Thanks very much for your help. I was also trying to export a query which does not work the same as a table. I changed my query to create a new table and then I export that table. It works like a dream.