exporting to excel

[Jim Hill]

Hello,
I use "DoCmd.TransferSpreadsheet acExport, 8, myTable,
myFile, False, """ command in a module to export the table
to an excel file. In the table there is a date filed and
it is sorted by date but the file does not come up sorted
by date. How can I keep the same sort option while
exporting the data.
Thanks,
Jim.

 

[Clinton]

Try instead of myTable, use My Query.
SELECT * FROM myTable ORDER BY myDateFiled;
Clinton

 

[Jim Hill]

thw query is working but when I used it instead of table
name in DoCmd.TransferSpreadsheet it does not work. I
tried select statament instead of table name, it does not
work either.
Thanks,
Jim.