how to sort output of transferspreadsheet function?

[Jorge Abiad]

I am transferring data from access table to excel 2003 as a pivot table.how do i sort the output using vba access when the columns to be sorted are date columns?

[nico5038]

Go into SQL textmode and add an Order By clause.
You can use the columns sequence number, Access wil "know" when it's a date.

Like: select * from tblX Order By 2, 3

Nic;o)