TransferSpreadsheet Function

J

JAK

When transfering a spreadsheet from Access to Excell the row are being
reordered. There is date field and a week field. Excell keep ordering
according to the week instead of the date. Is there a way this can be
changed?
 
J

John Vinson

When transfering a spreadsheet from Access to Excell the row are being
reordered. There is date field and a week field. Excell keep ordering
according to the week instead of the date. Is there a way this can be
changed?
Click to expand...

Rather than transferring from the Table, transfer from a Query with a
sort on the date field.

John W. Vinson[MVP]
 
Top