TransferText not writing output in sequence in Access vba 2010

[banterista]

I am using transfer text to create a text file and the output is randomly writing blocks of records out of sequence. Is there something I can do to correct this please?

My statement is :-

DoCmd.TransferText acExportDelim,,"TASExportTrans", namespath, False

 

[banterista]

Sorry guys I found a glitch in my input file please ignore this thread.

 

[banterista]

Although I've corrected my input file the output is still being produced in random sequence blocks.

 

[banterista]

I've now resolved this by assigning a key to the table. Then filtering out the key in a query which in turn, is used to drive the transfer text command.