On Apr 2, 10:20*pm, JCS wrote:
Hi Wayne,

Instead of copying and pasting from Access to Excel, why not create a macro
in Access that users the TransferSpreadsheet command? *Very easy to do.

John

Thanks John. I hadn't thought of that. I'll give it a go.