In a VBA module, I am trying to use TransferText to export a table's records in fixed-length format using the order that the records appear in the table. (The table is created by an update statement that inserts records in the order I need.) However, when I use TransferText, the record order in the exported fixed width file does not appear as it does in the table.
I can force the order by creating a query by hand that specifies the order and then exporting the records, but I need it to work dynamically.
In short, is there a way to force the record order to when exporting to fixed-width using TransferText? I suppose I could create a recordset and print out each record individually but calculating padding for a fixed-width, 30 field record is going to get messy.