I'm trying to export a union query in Access to a pipe delimited .txt file, with saved sorts, but the saved specification does not keep the sorts. Is there a way to save this export specification to include the sorts?
I'm trying to export a union query in Access to a pipe delimited .txt file, with saved sorts, but the saved specification does not keep the sorts. Is there a way to save this export specification to include the sorts?
The sort order will be in the query.
The query is sorted the way I need, but when I export to the pipe delimited file txt file, there is no sort at all.
It works for me, I wonder what can be different? How are you exporting, is it TransferText in VBA, or a macro? Are you using a saved specification?
I am using the TransferText with the saved specification in a macro.
Still am unable to reproduce your issue! Could you post your database? Just with the bare necessities needed.
I was able to figure it out! I was highlighting the columns in each query of the union query and sorting them separately...which didn't keep the sort.. I added the ORDER BY code at the end of the SQL and then it worked to save the sorts in the saved export specification.